Dear experts,

I copied an Excel file from other company. The file has 5 columns and 30+
rows. The 3rd column was for card numbers of 12 digits. When I further added
a new record under the last record, the card number I entered was xxxxx..2375
but when I pressed "Enter", the last digit changed to "0" - i.e. xxxxx...2370
instead of 2375. No matter how I change the cell format, it didn't help.
What's the problem of this and how can I fix it. Please kindly advise.

Thanks in advance.

You are limited to 15 digits total - your 12 + 4 is 16, so the last one is dropped. You could
preceed the whole thing with a single quote to convert the number to a string.

HTH,
Bernie
MS Excel MVP


"Freshman" wrote in message
...
Dear experts,

I copied an Excel file from other company. The file has 5 columns and 30+
rows. The 3rd column was for card numbers of 12 digits. When I further added
a new record under the last record, the card number I entered was xxxxx..2375
but when I pressed "Enter", the last digit changed to "0" - i.e. xxxxx...2370
instead of 2375. No matter how I change the cell format, it didn't help.
What's the problem of this and how can I fix it. Please kindly advise.

Thanks in advance.

Hi Bernie,

The number I entered was 12 digits also and not 16. I just showed the last 4
digits only for better understanding. Any ideas about the problem.

Thanks.

"Bernie Deitrick" wrote:

You are limited to 15 digits total - your 12 + 4 is 16, so the last one is dropped. You could
preceed the whole thing with a single quote to convert the number to a string.

HTH,
Bernie
MS Excel MVP


"Freshman" wrote in message
...
Dear experts,

I copied an Excel file from other company. The file has 5 columns and 30+
rows. The 3rd column was for card numbers of 12 digits. When I further added
a new record under the last record, the card number I entered was xxxxx..2375
but when I pressed "Enter", the last digit changed to "0" - i.e. xxxxx...2370
instead of 2375. No matter how I change the cell format, it didn't help.
What's the problem of this and how can I fix it. Please kindly advise.

Thanks in advance.

Hi,
Do right click in the tab name, view code, check if you don't have a
rounding formula there, if yes delete it

"Freshman" wrote:

Dear experts,

I copied an Excel file from other company. The file has 5 columns and 30+
rows. The 3rd column was for card numbers of 12 digits. When I further added
a new record under the last record, the card number I entered was xxxxx..2375
but when I pressed "Enter", the last digit changed to "0" - i.e. xxxxx...2370
instead of 2375. No matter how I change the cell format, it didn't help.
What's the problem of this and how can I fix it. Please kindly advise.

Thanks in advance.