Unknown Number Format

  • Thread starter Thread starter Freshman
  • Start date Start date
F

Freshman

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
 
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
 
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.
 
Back
Top