| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total Cell Error
We are running Excel 2003. The data was imported into Excel. We want to
get the total of 3 columns. However, we got the error message in the Total cell "#VALUE!". We resize the Total cell and it still did not work. The 3 columns were formatted as General. We reformatted to Numeric with 2 Decimals. We still got the same error message in the Total cell "#VALUE!". We reformatted the 3 columns to Currency, Accounting, and Custom. The Total cell still shows "#VALUE!". Do you have any suggestions on how to fix the values in the 3 columns? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| substract cell F from cell H and total into cell I | Excel Worksheet Functions | |||
| substract cell F from cell H and total into cell I | New Users to Excel | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
