Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I've come across an interesting issue in Excel 2000 in which if I enter the
following number (as an example), 1408685345915193, Excel will store it as 1408685345915190. Interestingly enough, should I enter a larger number, for example replacing the 1 at the beginning of the number to a 2 (theoretically a larger number than the one ending with a 3), then Excel accepts it no problem. Does anyone have any thoughts as to the root cause of this particular issue? Note that I can explain further if unclear. Thanks in advance for any feedback on this! -- Christian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Formatting a cell as "text" in the number catagory. | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |