Precede the numbers with an apostrophe which won't show in the cell.

OR pre-format the cell as Text then enter the 16 digits


Gord Dibben MS Excel MVP

On Mon, 10 May 2010 11:16:37 -0700, Leah S wrote:

I guess the credit card numbers are 16 digits. Wasn't thinking. Is there any way around the auto correct for that 16th digit?



Gord Dibben wrote:

You sure it is only 12 digits?
17-Mar-10

You sure it is only 12 digits?

Excel will add a zero after 15th digit.

Never seen after 12 digits.


Gord Dibben MS Excel MVP

wrote:

Previous Posts In This Thread:

On Wednesday, March 17, 2010 9:00 AM
Lyd wrote:

12 digit number rounding down why?
12 digit number entered with cell formatted as just a number is rounding to
end in zero all the time. Help please. cell is not locked

On Wednesday, March 17, 2010 9:20 AM
Bernard Liengme wrote:

Can you give an example or two?
Can you give an example or two?
best wishes