DISPLAYING NUMBERS AS WORDS
 

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?
--
bookman

DISPLAYING NUMBERS AS WORDS
 

Have a look here.

http://support.microsoft.com/default...23120121120120

HTH
Regards,
Howard

"bookman3" wrote in message
...
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?
--
bookman

DISPLAYING NUMBERS AS WORDS
 

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

regards
FSt1

"bookman3" wrote:

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?
--
bookman