| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Value" Error
I have a converted 2007 excel file that I am working in Excel 2003. There
are 31 worksheets that are for each day of a month and a summary worksheet that simply totals the cells across the worksheets. I am getting a "Value" error on the summary worksheet and the fornulas appear fine. I found however, that if I put a zero in each of the cells that are current blank (because there was no activity for that item on that particular day) then the error goes away and I get the total. Does anyone know what could be causing the problem - I have tried reformating all of the cells to a numeric setting and it does not help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| Shortcut key for "Paste Options" and "Error Checking" buttons? | Excel Discussion (Misc queries) | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Threaded Mode
