Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have created a chart with 2 columns of Nos. and a third column with the
results from the subtraction of column 1 from 2. At the bottom of each colum I also have the resultant of the column. the display is to 0 digits but the input on each box is to 2 digits. Also I have selected the numerical to show in Red and parenthesis if it is a negative No. The final resultant should equal 0. The problem that i'm having is that the final resultant shown as a negative 0 rounded off to whole No. If I extend the final result to show 30 digits, somewhere around the 20th. digit numbers show up instead of 0. Where do this numbers come from and how can I reduce the accuracy of the answer to just 2 digits. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I delete the formula but keep the results | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) |