| Share this post! | Vote this! |
|
Many times we need the amount in figures to be converted into words.
This is a typical requirement for writing checks or any other financial
reports. Microsoft Excel does not have standard function available for
this requirement. However there are customised functions available on
the Internet. One such solution is available at Allexperts.com.
Function available at the net covers USD as currency, whereas I needed it in Indian Rupees. I have modified this to give results in any currency. The revised version gives me results as shown in the screen cast below. more...
Display Numbers to Text.
You need to copy this to your regular macro module. Once you have added it to your file you can use function SpellNumbers to convert any number into words easily as you use any other function of excel.Function available at the net covers USD as currency, whereas I needed it in Indian Rupees. I have modified this to give results in any currency. The revised version gives me results as shown in the screen cast below. more...
0 comments:
Post a Comment