View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default How do I stop Excel from changing last digit in a number entry?

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.


--
Regards,

Peo Sjoblom



"elderly person" <elderly wrote in message
...
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?