How do I stop Excel from changing last digit in a number entry?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Whenever I try to tpye in a line of 16 numbers in my Excel Spreadsheet, Excel
changes the last digit to a zero. Anyone else have that problem? If so, how
did you solve it?
 
Precede the entry with an apostrophe of pre-format the cell(s) as text
Excel can only show up to 15 digits of precision, the rest will be truncated
to a zero. I am assuming you are not making calculations with these kind of
numbers, if you are Excel is not the right tool.
 
Back
Top