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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I prevent the cell from changing the number I enter? 2
When I type in a 1 it puts up .0001 how do I change this? 1
Data Entry Problem 3
mm:ss keeps changing to a date format 7
How do I get cells auto fill typing 2
Number Format Problem 2
numeric entered automatically divided 100! 1
Can't sum a series of numbers 10

Top