Dollar text

[Guest]

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?

 

[Jim Rech]

You might look at this article:

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

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

 

[dominicb]

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 ([email protected]) 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