Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Decimals Excel can Handle
I would like to know how many numbers of decimals the latest versions of
Excel can handle (2003 and 2007) Any help on how to find this data will be appreciated. Kind Rgds. -- Nicolas Cachanosky |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Number of Decimals Excel can Handle
In Excel Help: Specifications, Calculation
This tells you the precision is 15 decimal digits. But you should know how to interpret that; 0.0000000000000123456789012345 is still possible. Look here for more info: http://support.microsoft.com/kb/78113 -- Kind regards, Niek Otten Microsoft MVP - Excel "Nicolas Cachanosky" wrote in message ... |I would like to know how many numbers of decimals the latest versions of | Excel can handle (2003 and 2007) | | Any help on how to find this data will be appreciated. | | Kind Rgds. | -- | Nicolas Cachanosky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Whole Number and Decimals | Excel Discussion (Misc queries) | |||
Fill handle turned into a move handle | Excel Discussion (Misc queries) | |||
is there a limit to the number of rows the filter can handle? | Excel Discussion (Misc queries) | |||
Limit of number which sin() can handle? | Excel Worksheet Functions | |||
Merging Excel data to word, keeps including all decimals on number | Excel Discussion (Misc queries) |