| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel is rounding off more than 16 digits ?
I have encountered an unique problem, wherein, while opening a file where
more than 16 digits are there, excel automatically converts digits to 0 after 16th digits. Can anyone help me out to resolve this issue. e.g. if my number is 20071022123456789 it is automatically converts to 20071022123456700, last two digits 89 is automatically takes it as 00. How is it possible to take full number ........ 20071022123456789 ? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
| How to truncate to tenths digits without rounding | Excel Worksheet Functions | |||
| excel, how enter 15 digits in a cell without rounding off last? | Excel Worksheet Functions | |||
| Format monetary amount to 9 digits with No decimals without rounding | Excel Worksheet Functions | |||
| Mistery digits on excel | Excel Discussion (Misc queries) | |||
Threaded Mode
