Forum Discussion
Excel spreadsheet
I am trying to enter a number into an excel spreadsheet. It changes the last number that I enter to a zero. The number is 16 characters long. What can I do.
If you really need it as a number for calculations, you're out of luck - it's beyond the accuracy of Excel.
If it is a serial number or something similar, either format the cell as Text before entering the value, or prefix the value with a single quote (apostrophe) '.