| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I tell Excel to "ignore" invalid numeric data?
I have a spread sheet that I want to enter text in a field that is being used
in a SUM. I want Excel to ignore the text and treat it as Missing Values (or zero). The SUM currently gets a #VALUE! error. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel: Changing "numeric $" to "text $" in a different cell. | Excel Worksheet Functions | |||
| If A3=alpha numeric,"X", if A3=text,"Y", Blank | Excel Worksheet Functions | |||
| Having a pie chart ignore data fields equal to "0" | Excel Discussion (Misc queries) | |||
| error: "invalid character in text conent" How do I open this file | Excel Discussion (Misc queries) | |||
| "Invalid Web Query" error on opening a 2003 worksheet | Excel Discussion (Misc queries) | |||
Threaded Mode
