convert numercials into words

[Guest]

Hi

I need to learn the formula by which, I Excel converts numerical figures
into words automatically.

For e.g, In Cell A4, has numerical figure of 4000/- & i need excel to change
& display this figures into word ( Four Thousand ) automatically.

Pls advise the formula to do so ?

Awaiting

 

[Paul B]

Younus, have a look here for ways to do it

http://www.xldynamic.com/source/xld.xlFAQ0004.html

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003