ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Large integers in excel 2003 are rounded ?? Is this a BUG ? (https://www.excelbanter.com/excel-discussion-misc-queries/60414-re-large-integers-excel-2003-rounded-bug.html)

Kleev

Large integers in excel 2003 are rounded ?? Is this a BUG ?
 
Excel only has 15 digit precision. That is why when entering a 16 digit
credit card number, you would format it as text.

"Mike One" wrote:

Format a cell as number and set decimal places to 0.

Then enter 1818181818181818 in a cell and hit enter...

Excel then CHANGES to the number to:

1818181818181810 ???? WHAT ???

This can't be right can it ??, what am I missing ?



All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com