number names

N

nikunjpg

Is there a formula in excel which allows you to convert numbers to th
respective number names?
e.g. 21 will be retunred as "twenty one
 
N

nikunjpg

Thanks a tonne Mark!
But I wanted this on an on-going basis hence would be difficult t
specify a range.

Warm Regards
 
B

Bob Phillips

A couple of MS links for you to check out

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360
XL2000: How to Convert a Numeric Value into English Words

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q140704
XL: How to Convert a Numeric Value into English Words


Laurent Longre also has an addin that does it all for you. You can get it
http://longre.free.fr/english/

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top