Dollar text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top