HOW DO I DISPLAY NUMBERS AS WORDS IN EXCEL 2003?

S

Silvio

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
 
D

David McRitchie

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/strings.htm#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.
 
G

Guest

Silvio said:
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
Click to expand...


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
 
D

David McRitchie

Curiously strange accent ticzt for Text, and other stange sounds

"Bill Martin -- (Remove NOSPAM from address)" ..l...
 
Top