long number ends in 000

  • Thread starter Thread starter justanotherdayatwork
  • Start date Start date
J

justanotherdayatwork

Simple Question: when typing a long number in Excel (exceeding 15
characters), the last last numbers automatically turn to 0 (like in a ROUND
formula). I know this can be avoided by changing the number to text (eg by
inserting space or letter somewhere between the numbers) but because in this
case it's many other users who input the numbers, unaware of the bug, I
really need a way for them to be able to do so without having the right end
always change to "0" automatically...
any tips ?
 
this happens when Excel's max precision is exceeded - which is exactly
15 places
one way is to store it as text preceded by a single ' (apostrophe)
 
Format the cells as text before entering the numbers

BTW it's not a bug; it is the limit of Excel's precision; 15 decimal digits
 
Back
Top