ExcelBanter - convert number into corrseponding text

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - convert number into corrseponding text (https://www.excelbanter.com/excel-discussion-misc-queries/745-convert-number-into-corrseponding-text.html)

mustafa

convert number into corrseponding text

Hi,

I would like to know if there is a way to display text on the corresponding
number.

eg.
I type 530,000
and it would show me Five hundred and thirty thousand

Bob Phillips

Take a look at http://www.xldynamic.com/source/xld.xlFAQ0004.html

--

HTH

RP
(remove nothere from the email address if mailing direct)

"mustafa" wrote in message
...
Hi,

I would like to know if there is a way to display text on the
corresponding
number.

eg.
I type 530,000
and it would show me Five hundred and thirty thousand

All times are GMT +1. The time now is 06:46 PM.