Convert Number Format To Text In Excel
Hello Guys,
Today I am giving information About How You Can Convert Format Number To Text In Excel ,
So , let's start blog.
excel is a powerful tool developed by Microsoft which is mainly used for accounting and various other application one of the formula which excel doesn't have can be added by a simple vb project
6) Paste The Code Which You Have Copied In The Module
Today I am giving information About How You Can Convert Format Number To Text In Excel ,
So , let's start blog.
excel is a powerful tool developed by Microsoft which is mainly used for accounting and various other application one of the formula which excel doesn't have can be added by a simple vb project
2) Open The Excel Sheet In Which You Want To Use The Formula.
3) Press "Alt+F11" Key In Your Keyboard
4) A Window Showing VBA (visual basics application) Will Open In Your Sheet
5) Open A New Module
7) Save the file (note :you will be popped up that this file cannot be saved simply give a "no" to the dialogue and save the file in a macro enabled format)
8) Now you can use the function spellno very easily
9) in the cell you want a converted no type =spellno(cell no from where you will take the value)
10) and its done .
now you can convert the number to words easily
Post a Comment