Two ways to get that enabled.

1. User checked it.

2. VBA code checked it.


Gord Dibben MS Excel MVP

On Fri, 30 Nov 2007 09:56:02 -0800, DLJames .(donotspam)
wrote:

That fixed it! Thank you! Now the only question left, is how did that box
get checked in the first place? One minute I could enter just fine and then
later it was all crazy with zeros! Thank you again for your help. Sanity is
restored!

"Mike H" wrote:

Maybe,

Tools|Options|edit

and un-check fixed decimal places

Mike

"DLJames" wrote:

All the sudden my worksheet started adding a decimal and 10 zeros to my
number entries. I've tried to format the cell/column again, but it won't
change. What have I done and how do I fix it?