| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Large integers in excel 2003 are rounded ?? Is this a BUG ?
I find this ridiculous and a bug. It will really screw up your excel sheet
when you are using CC numbers (which I found the issue with). I'm currently using the 'quote' workaround but I can't believe a spreadsheet programme would just do this without warning. Microsoft - BAD DOG! "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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
| Excel Re-calculation 2000 compared to 2003 | Excel Discussion (Misc queries) | |||
| Problems using Excel 2000 to open/save file saved in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 random number generator | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
