General discussion

Locked

Excel not calculating correctly

By dbc ·
The Finance Dept computers run Excel 2000 in a Windows 98 environment. Spreadsheets that must calculate are normal procedure. Recently, however, when they have gone to replace numbers in reusable spreadsheets, the figures have not calculated correctly. If we highlight the set of cells from top to bottom and use the Autosum, the total will not be correct. F-9 to recalculate does not work. There are no formulas in those particular cells. We have even copied and pasted to another place on the spreadsheet and it still miscalculates. Totally clearing the cells and re-entering data does not help. The only way to get a correct total is to manually insert it. No luck looking for answers on the MS Excel website. We are desperate for an answer as the Finance Dept. runs on these spreadsheets!

This conversation is currently closed to new comments.

11 total posts (Page 2 of 2)   Prev   01 | 02
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Excel not calculating correctly

by wordworker In reply to Excel not calculating cor ...

Select the columns that contain the amounts and format them as General. I've seen this happen MANY times when someone has manually formatted a range of cells as Text -- no matter what you put in those cells, Excel treats them as zero-value in calculations.

Back to Software Forum
11 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums