Excel Number Format

[jps3700]

I am trying to find out if a cell can be formatted so when you enter an amount for example: 531.80 it will convert that to text as: Five Hundred Thirty-One Dollars & 80/100 cents.

Please help, I have look all over the place!

Thanks in advance,

John Silva
Las Vegas, NV.

 

[Dreamboat]

Go here:

http://www.excel-vba-access.com/freeworkbooks.htm

Scroll down a little bit and download (right-click and save target as) "Figures to Letters"
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[jps3700]

Thanks! It worked perfectly...

 

[Dreamboat]

Great!
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word