Hi Ginny, (and ....., and Mark)

I have trouble reading Mark's page with any browser and reloading did not
change colors (Firefox and Mozilla appear same, differs from both
Internet Explorer and Opera in color choices) rather than play with
the RGB decimal values, used CTRL+A to select everything so can
be seen while selected. I loaded up the spreadsheet indicated and it has subroutines
and not functions. Hardly usuable and in anything with numbers spelled
out in words you would want to see the original numbers as well.
(When four different browsers don't render a page readable and reloading
doesn't change anything -- I think the page is not a good example).

I would suggest any of the functions that you find
Numbers to words (as in check protection wording) (#numberstowords)
http://www.mvps.org/dmcritchie/excel...numberstowords

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

"exceluserforeman" wrote in message
...

NumbersToLongText.xls

http://www.geocities.com/excelmarksway

"Ginny@apl" wrote:

I am creating a teplate in excel and need to write a formula that takes a
number in it's currency form and converts it to the written form...much like
what you would find on a check. How do I do this?

Ex. $1000.00 converts to One Thoudand Dollars and 00/100.