| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"#N/A" -- can I convert to a "0" (zero)?
I have just learned to pull query data into a spreadsheet through VLOOKUP.
However some years have no data in the query and it returns an #N/A in the cell. I cannot figure out how to convert those to a '0'. Any master of Excel out there have any suggestions? Thanks in Advance! Branchie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert "yes" and "no" to "1" and "0", respectively | Excel Worksheet Functions | |||
| want to return "n/a" or "0" | New Users to Excel | |||
| Convert decimal degree (lattitude/longitude) into Degree, | Excel Discussion (Misc queries) | |||
| CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Threaded Mode
