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