Dollar text
 

Hi
I do my proposal in Excel and I'm wondering if I can format a cell to
convert dollar amounts $100.00 to One Hundred Dollars and 00/100 like when I
write a Check?

You might look at this article:

http://support.microsoft.com/default...b;en-us;213360

--
Jim
"Plumb34" wrote in message
...
| Hi
| I do my proposal in Excel and I'm wondering if I can format a cell to
| convert dollar amounts $100.00 to One Hundred Dollars and 00/100 like when
I
| write a Check?
|
|

Good afternoon Plumb34

This can only be handled by getting into custom function territory and
writing your own function. I have a free add-in available to anyone who
asks for it ) which will handle this through a
custom formula which can give the result in £, $ and Euros. Please send
me an e-mail if you would like to use this.

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=394619