| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem using formula after formatting cells
I need to use dates and numbers in the same column and total only the numbers
using a formula. Once I changed the specific cells with the dates to "text" so that they would not be included in the sum, I can no longer sum the numbers. The problem doesn't go away if the cells are formated to "number", "general" etc. The sum is always "0". -- Stacey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Grid problem with formatting cells... | New Users to Excel | |||
| Formatting & Formula Problem | Excel Worksheet Functions | |||
| Currency formula/formatting problem | Excel Discussion (Misc queries) | |||
| Formatting cells, Need help solving a problem with excel | Excel Discussion (Misc queries) | |||
| Conditional formatting with dates formula problem. | Excel Discussion (Misc queries) | |||
Threaded Mode
