Prev: How to make the cursor stay in the cell when entering data.
Next: standard toolbar does not show up when starting up
From: bookman3 on 13 Jan 2010 22:16
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
From: L. Howard Kittle on 13 Jan 2010 22:30
Have a look here.

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

HTH
Regards,
Howard

"bookman3" <bookman3(a)discussions.microsoft.com> wrote in message
news:1AD48A8E-5282-4739-9148-D1D3C99EF0DB(a)microsoft.com...
> 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


From: FSt1 on 13 Jan 2010 23:08
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
 | 
Pages: 1
Prev: How to make the cursor stay in the cell when entering data.
Next: standard toolbar does not show up when starting up