$1.00 as "One dollar"

Hi Dena,

A couple of MS links for you to check out

http://support.microsoft.com/default...;EN-US;Q213360
XL2000: How to Convert a Numeric Value into English Words

http://support.microsoft.com/default...;EN-US;Q140704
XL: How to Convert a Numeric Value into English Words


Laurent Longre also has an addin that does it all for you. You can get it
http://longre.free.fr/english/


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dena" wrote in message
...
I would like to show a number in currency format in its written format, as
you do on a check.
Does anyone know how to do that in Excel 2000?

Hi
No built-in Function, but you can build your own User Defined Function
using
the info at:

http://support.microsoft.com/default...;EN-US;q213360

OR download Laurent Longre's MOREFUNC.XLL from he

http://longre.free.fr/english/index.html

Has a Numbers to Words Function along with many other useful Functions.

And a couple more from Andy Wiggins for good measure........

This file might be a help:
http://www.bygsoftware.com/examples/...s/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains two methods to convert numbers to words and two cheque
writing
routines.



--
Regards
Frank Kabel
Frankfurt, Germany


Dena wrote:
I would like to show a number in currency format in its written
format, as you do on a check. Does anyone know how to do that in
Excel 2000?

Hi Dena:

I believe I have a solution for you. I have sent an Excel file to your
email address listed below.

Hope this helps!


Tom



"Dena" wrote in message
...
I would like to show a number in currency format in its written format, as
you do on a check.
Does anyone know how to do that in Excel 2000?