DISPLAYING NUMBERS AS WORDS

[bookman3]

Hi

if a formula returns a result in cell A1 of 27,300,000, I would like to
display this result in words in Cell A2 i.e. twenty seven million three
hundred thousand.

How can I do it?

 

[L. Howard Kittle]

Have a look here.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360#XSLTH3123121123120121120120

HTH
Regards,
Howard

 

[FSt1]

hi
that can get a tad complicated. see this site.
http://www.xldynamic.com/source/xld.xlFAQ0004.html

regards
FSt1