If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rounding in Excel
I have a table that has numbers "hard coded" back to another spreadsheet in
the workbook. Excel says that the numbers (961+73-60=974) in the table. However, entered separately without decimals, Excel says (961+73-60=975). I am concerned that wehn people read my table, they will see that the numbers don't add up. Is there any way short of re-entering whole numbers to solve this problem. Thanks in advance. Al Charbonneau |
#2
|
|||
|
|||
Rounding in Excel
Bit confusing; we need more info
What formula are you using? What at eh numbers on the other sheet? You say "However, entered separately without decimals, Excel says (961+73-60=975)" This is clearly wrong (1+3-0 = 4) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Al Charbonneau" Al wrote in message ... I have a table that has numbers "hard coded" back to another spreadsheet in the workbook. Excel says that the numbers (961+73-60=974) in the table. However, entered separately without decimals, Excel says (961+73-60=975). I am concerned that wehn people read my table, they will see that the numbers don't add up. Is there any way short of re-entering whole numbers to solve this problem. Thanks in advance. Al Charbonneau |
Thread Tools | |
Display Modes | |
|
|