Excel is dividing my entries...why??

J

JMc

OK, I'm not an expert @ Excel, but I've used it enough to know that what is
happening is not right. Everytime I try to enter a number, Excel is dividing
the number by 10,000 and displaying it as such.

For example, if I enter "300" it returns "0.03" instead.

There is no formula in the cell and the format of the cell doesn't make any
difference.

It's probably something simple and stupid, but I've been through all of the
drop-down menus and settings and I can't find anything wrong!

Help please!!

John
 
K

Kevin B

Click TOOLS on the menu and select OPTIONS. In the OPTIONS dialog box, click
the EDIT tab and remove the check mark from the FIXED DECIMAL PLACES checkbox
and you'll be good to go.
 

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

numeric entered automatically divided 100! 1
Number automatically divided by 100, why? 4
Number entries are automatically divided by 100 - Excel 2003 1
Excel 08 divides numbers by 100 2
Excel divides every number by 100 upon manual data entry 2
Typed numbers are divided by 10 (Excel 2007) 2
My excel2000 divide numbers per 10 why? 2
Excel 2003: Keeps applying auto-font settings I don't want 1

Top