convert a number

[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'?

 

[David McRitchie]

Using a User Defined Function, but then you would want both
the number and wording Some links in
http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords

Some recent discussions have pointed out a difference in US and
British usage. In the US the "and" means a decimal point for fractional
part. I had always assumed that those that had an and somewhere else
were simply incorrect.

 

[Arvi Laanemets]

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

Using a User Defined Function, but then you would want both
the number and wording Some links in
http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords

Some recent discussions have pointed out a difference in US and
British usage. In the US the "and" means a decimal point for fractional
part. I had always assumed that those that had an and somewhere else
were simply incorrect.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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

 

[JohnI]

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

Using a User Defined Function, but then you would want both
the number and wording Some links in
http://www.mvps.org/dmcritchie/excel/strings.htm#numberstowords

Some recent discussions have pointed out a difference in US and
British usage. In the US the "and" means a decimal point for fractional
part. I had always assumed that those that had an and somewhere else
were simply incorrect.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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