format of number keeps changing

  • Thread starter Thread starter lim37
  • Start date Start date
L

lim37

I have an excel spreadsheet and in 2 of the columns i have a list of numbers,
the format of the cells for each column are the same but on the second
column when i type in a number and hit enter to go to the cell below it
changes the digit at the end of the number to a zero, for example if i put in
12345 when i hit enter it changes to 12340, this doesnt happen on the column
beside it even thought the formatting of the numbers for each cell in both
columns is the same.

Any ideas?????
 
Is the number more like

1234567890123456

and it becomes

1234567890123450

?? If so, you're running into XL's limit of 15 decimal digits of
precision. If you don't need to use the value in math, format the cells
as Text, or prefix them with an apostrophe.
 
Hi,

This behavior is inconsistant with normal Excel behavior assuming both
columns are really formatted to the same formats.

What exactly are the numbers you are entering?

1. Excel stores number up to 15 digits after that is displays 0's regardless
of how many digits you type
2. There could be a VBA routine which is modifying the entry. Check to see
if there is any code in your file.

If this helps, please click the yes button.

Cheers,
Shane Devenshire
 
Back
Top