Why does an integer entered in the cell divide by 10?

J

juglansjames

Within the spreedsheet aplication on entering an integer eg 56789 the entry
automatically divides by 10 eg 5678.9

Despite formating the cell to 'Number' 0 decimal places the error remains.
The cell has no generic 'Function' application.

Howver of note if 56789.00 is entered then the divison by 10 does not occur
 
G

garfield-n-odie [MVP]

In Excel, click on Tools | Options | Edit tab | uncheck the
"Fixed decimal places" box | OK.
 

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

integers entered automatically divide by 10 2
Typed numbers are divided by 10 (Excel 2007) 2
two integers in one cell 3
Mapping integers to strings 6
EXCEL CELLS DIVIDE CONTENT BY 100 WHEN ENTERED 1
SUMPRODUCT QUESTION?, Ratios 3
preventing division by 10000 when entering cell value in xcel 2
entering whole numbers: formula bar 2

Top