convert a number

  • Thread starter Thread starter jim
  • Start date Start date
J

jim

Is there a way to automatically convert a number to text,
for example, if you enter '536' in a cell it will convert
it to 'five hundred thirty six'?
 
Hi

With UDF, you can get number as text in another cell, i.e. you enter 536
into one cell, and the text 'five hundred thirty six' appears in another
cell. To get it working for same cell, you have to use worksheet's Change
event. At first you have to check, was the entry in predefined range, then
was it a number. When not, exit, otherwise continue with code like in UDF.


Arvi Laanemets
 
David,

Interesting. We use the British version in Australia too.

We say "five hundred point three six" for 500.36. "Five hundred and
thirty-six" means 536 here too.

In currency we say five hundred and thirty-six dollars ($536) or five
hundred dollars and thirty-six cents ($500.36).

regards,

JohnI
 
Back
Top