View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Zero appears at the end of a string of 16 digits. Two zeros after

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.)

cawhitaker wrote:

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