how to convert number to text in english example 123 ---->one hun.

[John]

i would like to convert a number available in one cell into wording in
another cell
Example
Cell Data
A1 1025
D15 one thousand twenty five

 

[Norman Jones]

Hi John,

See:
Microsoft Knowledge Base Article - 213360
XL2000: How to Convert a Numeric Value into English Words

 

[Tom Ogilvy]

http://longre.free.fr/english/index.html

download Laurent Longre's free addin Morefunc.

It has a function that will do this for you.

 

[Norman Jones]

Hi John,

The link is:

http://tinyurl.com/5um74