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

Have a look here.

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

HTH
Regards,
Howard

"bookman3" <(E-Mail Removed)> wrote in message
news:1AD48A8E-5282-4739-9148-(E-Mail Removed)...
> 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

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