Excel - can you convert numbers to words

[Omar]

Is it possible to convert numbers in an Excel spreadsheet cell to read as
words?

Example: Convert $500.00 to read as: Five Hundred Dollars and 00/100's

 

[Lem]

Is it possible to convert numbers in an Excel spreadsheet cell to read as
words?

Example: Convert $500.00 to read as: Five Hundred Dollars and 00/100's

1. In the future, ask Excel questions in an Excel newsgroup.
2. Or use Google.
3. Or go to Microsoft Office Online (for whichever Office product you
need help): http://office.microsoft.com/en-us/help/FX100646671033.aspx
4. Or use the product's Help feature.

A solution for Excel 2007 provided by option 3 above:
http://office.microsoft.com/en-us/excel/HP100791911033.aspx?pid=CH100645341033

--
Lem -- MS-MVP

To the moon and back with 2K words of RAM and 36K words of ROM.
http://en.wikipedia.org/wiki/Apollo_Guidance_Computer
http://history.nasa.gov/afj/compessay.htm

 

[Big_Al]

Lem said this on 2/27/2009 9:27 PM:

1. In the future, ask Excel questions in an Excel newsgroup.
2. Or use Google.
3. Or go to Microsoft Office Online (for whichever Office product you
need help): http://office.microsoft.com/en-us/help/FX100646671033.aspx
4. Or use the product's Help feature.

A solution for Excel 2007 provided by option 3 above:
http://office.microsoft.com/en-us/excel/HP100791911033.aspx?pid=CH100645341033

Omar: If you find a solution, post it back. I glanced over some of
the suggestions in Lem's links and found nothing, but then I only
glanced. DOLLAR seemed to be the one, but fell sort. So maybe I'm
not reading the help enough. Still I have no need other than
curiosity, thus minimal effort was put into it.

I wrote an accounting application (until I retired a year ago) and we
printed checks with the amount in english. Proprietary engine & it was
a built in function we had the C++ programmers write for us to convert
10.00 to a string. After 20 years and prices escalating we found that
some wordy numbers would not fit into 70 characters. The original code
was written to limit the string to 70 characters as that was computed to
be the most that could go in a check printed on a dot matrix printer
leaving room for "Amount: " and white space. Oh the lack of foresight
and dot matrix!!! The default if more than 70 chars, was to just not
convert it. We found years later as prices went up, $1,787,787, which
seems high but businesses did start paying for a years service on stuff
and larger businesses had larger checks. The checks would not print.
Fun fun fun.! No solution is perfect.

 

[Lem]

Lem said this on 2/27/2009 9:27 PM:
Omar: If you find a solution, post it back. I glanced over some of
the suggestions in Lem's links and found nothing, but then I only
glanced. DOLLAR seemed to be the one, but fell sort. So maybe I'm
not reading the help enough. Still I have no need other than
curiosity, thus minimal effort was put into it.

I wrote an accounting application (until I retired a year ago) and we
printed checks with the amount in english. Proprietary engine & it was
a built in function we had the C++ programmers write for us to convert
10.00 to a string. After 20 years and prices escalating we found that
some wordy numbers would not fit into 70 characters. The original code
was written to limit the string to 70 characters as that was computed to
be the most that could go in a check printed on a dot matrix printer
leaving room for "Amount: " and white space. Oh the lack of foresight
and dot matrix!!! The default if more than 70 chars, was to just not
convert it. We found years later as prices went up, $1,787,787, which
seems high but businesses did start paying for a years service on stuff
and larger businesses had larger checks. The checks would not print.
Fun fun fun.! No solution is perfect.

Well, Al, you got me. I guess that's why I'm not an Excel expert.

The "number to text" functions such as DOLLAR and TEXT convert data
formatted as numbers into data formatted as text. What the OP needs is a
conversion into English words.

So I fall back on #1. The place to ask Excel questions is in an Excel
newsgroup. Or #2, which gives this VB script:
http://www.ozgrid.com/VBA/ValueToWords.htm And no, I have not tested it.

--
Lem -- MS-MVP

To the moon and back with 2K words of RAM and 36K words of ROM.
http://en.wikipedia.org/wiki/Apollo_Guidance_Computer
http://history.nasa.gov/afj/compessay.htm

 

[Terry R.]

The date and time was Thursday, February 26, 2009 12:12:01 PM, and on a
whim, Omar pounded out on the keyboard:

Is it possible to convert numbers in an Excel spreadsheet cell to read as
words?

Example: Convert $500.00 to read as: Five Hundred Dollars and 00/100's

Hi Omar,

Back in 1985, I created a spreadsheet for printing to 3 checks on a page
using Lotus 123. I had it configured to convert the dollar amount into
text on the line below the name on pre-printed checks. I would be
surprised if Excel today couldn't do that.


Terry R.