# WTF is Wrong With Excel? It Changes My Numbers!

#### Justinian

##### Well-known Member
In my spreadsheet, I am trying to write out my sixteen-digit account number of 8448200017875626 but Excel is chnaging that last 6 to a 0 and I cannot figure out why. I cleared all formating but it still does it.

What the heck is Excel doing to me?!

### Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result
The 16 digit number is too big for Excel to handle. Change the format of the cell to Text then enter it.

If it's just an account number, format the cell to text.

Excel won't let you input numeric data with that many significant digits, so it converts anything after the 15th digit to zero.

usually a number that large you need to format the cell to text. I can't remember the why - I might see if I can found that for you

usually a number that large you need to format the cell to text. I can't remember the why - I might see if I can found that for you

It is because Excel uses a floating-point decimal. Chip Pearson's Article on this topic explains a LOT: from why it can only be precice to 15 digits, and also why some simple addition/subtractions can seem to error.

But I can format as a number and it accepts all the digits, but only chnages the last one.

look at the MrKowz & my links

Yes, that's the point.

If it's formated as number, you can key in as many digits as you like, but it will convert anything after the 15th digit to zero.

You're entering a 16 digit number, so it converts the 16th one to zero.

To get round this, format the cell as text.

I can't believe I did not know that already!

Thanks everyone!!

Replies
13
Views
251
Replies
5
Views
250
Replies
6
Views
201
Replies
2
Views
157
Replies
2
Views
85

1,221,503
Messages
6,160,184
Members
451,629
Latest member
MNexcelguy19

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back