Bug part of rounding issues?

  • Thread starter Thread starter ted
  • Start date Start date
T

ted

Paste any of the following into a cell and the last digit gets changed to a
zero. This is screwing up our call detail records that contain international
numbers dialed by customers.

9011390292608271
9011390292608272
9011390292608273
9011390292608274
9011390292608275
9011390292608276
9011390292608277
9011390292608278
9011390292608279

If I format the cell as text, Excel changes the contents to 9.01139E+15 no
matter how wide the column is.

Is ther any way to make Excel just display the numbers as entered?

Thanks
 
Not a bug - see "Specifications" in XL Help: XL only retains 15 decimal
digits of precision.

Format the cells as Text BEFORE entering, or prefix entries with an
apostrophe (').
 
Back
Top