Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am having trouble with Excel displaying the following numbers:
985.161000874592 - it will not accept and display the last digit (2) of this number. It will display any other number typed there, just not the number two. When you type in the number 2 Excel changes it to a 1. The same occurs with 985.121002873173. In this case the last number (3) is changed to a 2. Excel will accept any other number here other than 3. I have read about the 16 digit limitation in Excel, but it is weird that it will accept and display all last digits in these two numbers except the numbers 2 and 3. Any ideas. By the way, when formatted as text, Excel will display as typed. It's just that I would prefer these to be formatted as numbers with 12 decimal places. -- Pat |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Number Formats | Excel Discussion (Misc queries) | |||
Number Formats | Excel Discussion (Misc queries) | |||
Outline different number formats | Excel Discussion (Misc queries) | |||
[$-409] in Custom Number Formats | Charts and Charting in Excel | |||
number formats | Excel Worksheet Functions |