| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
ljontheroad wrote:
How do I get Excel to correctly add a column of numbers that have each been rounded to 2 decimals? It seems to always remember the unrounded figures; therefore, the sum of the column of figures is never correct. It's always off a few decimal points. This seems an amazing short-coming for a spreadsheet program. Is there a fix for this problem? Amazingly enough, having used Excel extensively over the last ten years or so for Management Accounting purposes, I've never noticed this! Must be something to do with your workbook! -- Interim Systems and Management Accounting Gordon Burgess-Parker Director www.gbpcomputing.co.uk |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I see column headings of hidden columns in Excel before u. | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) | |||
| Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Threaded Mode
