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

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?

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?