Automatically changing my numerical entry- when I don't want it to

C

Christina08

When I enter a number excel is multiplying it by 100. I've tried messing
with Format, Cells, Number but that doesn't help. I've also tried tools,
options, edit and unchecking the fixed decimal places...

Help please!
 
P

Peo Sjoblom

Tools>options>edit clear the check mark in fixed decimal places



--


Regards,


Peo Sjoblom
 
G

Gord Dibben

One sheet? All sheets? One workbook? All workbooks?

Since you state you do not have "fixed decimals" checked I can only suggest
some type of event code.

Have a look through whatever workbook or sheet you're having the problem
with.


Gord Dibben MS Excel MVP
 
Top