View Single Post
  #3   Report Post  
cawhitaker
 
Posts: n/a
Default Zero appears at the end of a string of 16 digits. Two zeros a

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

"Dave Peterson" wrote:

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