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

E

elderly person

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?
 
P

Peo Sjoblom

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I remove the last 8 digits from every number 1
Excel does not accept text format! 0
Improving Macro That Keeps First Letter 0
Keep First Letters, with exceptions 0
Entering 16 digit numbers in cell 3
16 digit numbering 8
For John, et al. Re Combining Columns (previous post) 4
Excel suddenly crippled by Just-In-Time Debugging 2

Top