Dollar text

[Plumb34]

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...b;en-us;213360

--
Jim
"Plumb34" <Plumb34@discussions.microsoft.com> wrote in message
news:DE4A7F72-B1BE-4AA1-95BE-630B662951A7@microsoft.com...
| 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 (dominic@dom-and-lis.co.uk) 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