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

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!

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

Toolsoptionsedit clear the check mark in fixed decimal places



--


Regards,


Peo Sjoblom

"Christina08" wrote in message
...
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!

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

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

On Tue, 19 Aug 2008 08:50:01 -0700, Christina08
wrote:

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!