| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Everything equals zero
Thanks Elkar. I actually checked both of those. I also closed and opened
the spreadsheet. Still nothing. Closing and opening it a third time however fixed it. Maybe I wasn't patting my head at the right speed. "Elkar" wrote: Based on what you've mentioned, I'd suspect that your cell formatting has been set to "0". Thus, yes, everything would in fact display as 0. Check the Cell Formatting, and change to 0 (no quotes) or General, etc... Another possibility to check, is make sure Automatic Calculations is turned on. TOOLS--OPTIONS--CALCULATION Tab--Check Automatic HTH, Elkar "CWillis" wrote: I have a workbook I have been using all day. All of the sudden, everything equals zero. Well, anything with an equals sign in front of it that is. (Except column B, that one is fine.) I'm not sure examples are needed, but just in case: =1+1 gives "0" =A1 gives "0" etc. Anyone know why/How to fix this? -Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a cell equals _, at the next row that equals _, return value fr | Excel Worksheet Functions | |||
| If cell is left blank, or equals zero, then cell equals a different cell | Excel Discussion (Misc queries) | |||
| if a:a (range) equals january and c:c equals gas then add g:g ($) | Excel Worksheet Functions | |||
| IF equals this OR this | Excel Worksheet Functions | |||
| custom filter does not work when selecting 'equals' X AND 'equals' | Excel Discussion (Misc queries) | |||
Hybrid Mode
