Zero appears at the end of a string of 16 digits. Two zeros after

[Guest]

After I enter 16 digits into a cell, a zero appears at the end of the 16
digit number. Two zeros appear at the end of 17. What is causing this?

 

[Dave Peterson]

Excel supports 15 significant digits. If you want to see more, you can
preformat the cell as text (then type in your 16 digit entry).

Or you can prefix your entry with an apostrophe:

'1234123412341234

(Both of these will leave the value in the cell as text.)

 

[Guest]

Is there any way to change the 15 to say 20?

Excel supports 15 significant digits. If you want to see more, you can
preformat the cell as text (then type in your 16 digit entry).

Or you can prefix your entry with an apostrophe:

'1234123412341234

(Both of these will leave the value in the cell as text.)

 

[Dave Peterson]

Not than I'm aware of.

Is there any way to change the 15 to say 20?

 

[Guest]

Thanks, Dave. This answered my question. It is greatly appreciated.