Data entry error

G

Guest

When entering numbers, excel divides the entry by 10, so that by typing in
"220000", the cell contents become "22000". Reformatting the cell then has
no effect on the contents of the cell, changing it to "22,000" for example.
The error does not occur if you type either a comma separator or a decimal at
the end of the numerical entry. Is there any known fix for this? Thanks for
any help.
 

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

Find Numeric data 16
Fill/Extend Series adding decimal points to some numbers 1
Last entry in a column 6
Why does an integer entered in the cell divide by 10? 1
Help with a formula 10
count no. of times a character occurs in a cell 2
Entry in cells error, Excell 5
Averaging every 5th cell while omitting zeros 4

Top