HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003?
 

Hello, HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? (e.g. the number 102
should display Onehundredtwo (like in a personal bank check).

thank you.
Silvio

Well I don't know of anybody writing macro to print out the amounts
without spaces, but you can change the macros, a bit harder to change
the add-ins (depends on if they were VBA or not and not protected).

Take a look at my page on Strings
.http://www.mvps.org/dmcritchie/excel...numberstowords
and note that in the US the word "and" is only used before
the fractional portion, which may differ from your own
usage so check out each of the solutions for one that fit s your needs.
---
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

"Silvio" wrote in message ...
Hello, HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? (e.g. the number 102
should display Onehundredtwo (like in a personal bank check).

thank you.
Silvio

Silvio wrote:
Hello, HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003? (e.g. the number 102
should display Onehundredtwo (like in a personal bank check).

thank you.
Silvio


A Google search of "Excel numbers as words" produces the following web page as
the first hit:

http://www.meadinkent.co.uk/xlnumberstext.htm

Google provides a lot of other links if you want an alternative solution.

Bill

Curiously strange accent ticzt for Text, and other stange sounds

"Bill Martin -- (Remove NOSPAM from address)" ..l...
A Google search of "Excel numbers as words" produces the following web page as
the first hit: http://www.meadinkent.co.uk/xlnumberstext.htm