Sure, Raza. Tools--Options, Edit tab. Change Fixed decimal to -3. You may
want to record yourself a macro of yourself doing this setting, and then
turning it off (put the two macros as toolbar buttons), so you don't have ot
use it all the time. See:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com

"Raza" wrote in message
...
I have a spread sheet that is dealing with home prices. As you can guess,
I'm typing a lot of zeros.

Instead of typing 300,000 for a home price, is there anyway that I could
format a cell so I type 300 and the number pops up as $300,000?

Thanks.