You could create a worksheet event change macro. The Macro could detect your
entry of data into a cell and automatically multiply by 1,000. It is much,
much easier to enter 300 into an un-used cell, like say D1, and use =1000*D1
where you want the full, big, number.
--
Gary''s Student


"Raza" wrote:

I learned that the hard way, any other solutions?

"Tom Ogilvy" wrote:

Just be warned,
Setting fixed decimal to -3 will add 3 zeros to the end of any number you
type.

It can't be selectively applied.

--
Regards,
Tom Ogilvy


<Andy wrote in message ...
Hi

Go to Tools/Options/Edit tab and set Fixed Decimal Places to -3

Andy.

"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.