Large integers in excel 2003 are rounded ?? Is this a BUG ?
I just tried it and Excel did the same thing. Looks odd. I removed all
formatting though and the number changed to scientific notation 1.81818E+15 Probably some quirk with the number being so large. You might want to explore Microsoft's Knowlege base on this. "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 02:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com