Your solution seems perfect. The only problem is that I don't know how to
add code to a worksheet! How do I do that?

"Gary''s Student" wrote:

Here is some worksheet code that will auto-multiply by 1000 for entries in
cells A2 thru A10:

Sub Worksheet_Change(ByVal Target As Excel.Range)
If Intersect(Range("A2:A10"), Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Value = Target.Value * 1000
Application.EnableEvents = True
End Sub

--
Gary's Student


"Gary''s Student" wrote:

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.