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

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?

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

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

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

Not than I'm aware of.



cawhitaker wrote:

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


--

Dave Peterson

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

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

"Dave Peterson" wrote:

Not than I'm aware of.



cawhitaker wrote:

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


--

Dave Peterson