| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can i get a sum function to recognise X (letter) as a number?
I need to get a sum function to recognise an 'x' or 'NA' as a number as not
to mess up an overall percentage function later on in the worksheet. This is for an inspection & cells would usually have a 1 - 5 value placed in them but sometimes the field is not applicable. Is it possible?? Can anyone help?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i get formula to recognise text as = to a number?(excel) | Excel Worksheet Functions | |||
| How to recognise a small letter as being different to a capital le | Excel Discussion (Misc queries) | |||
| How do I get Excell to recognise 0 at the beginning of a number? | Excel Discussion (Misc queries) | |||
| change headers from letter to number/number to letter | Excel Worksheet Functions | |||
| column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Threaded Mode
