all numbers are divided by 10

J

Jeff

On a blank worksheet, when I enter a number, it is
automatically divided by 10. If I enter 123, it shows as
12.3
 
L

Lady Layla

Tools Options Edit Uncheck the box next to Fixed Decimal


: On a blank worksheet, when I enter a number, it is
: automatically divided by 10. If I enter 123, it shows as
: 12.3
 

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

New Excel doc automatically divides any number typed by ten - Need 1
Number entered in cell getting always divided by 100 ! 5
default format for Excel numbers 2
All number inputs are divided by 100 ? 2
Typed numbers are divided by 10 (Excel 2007) 2
Numbers divide by 10 in any cell... 6
Why are the data always divided by 10 in Excel? 1
I don't need the actual value but what is shown 2

Top