| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Replacing an ERROR message with "NA"
I have created a table and some of the cells display the message "#DIV/0"
which I expected would happen, yet I want to automate the document so that all error messages are replaced by the text message "NA". It's a large document and it would take a very long time to change each cell manually so I was hoping someone could help me. I also update it often, therefore I need to keep the formula in the cell and if I type NA in the cell the formula will be erased... Does anybody know how to fix this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| question about excessive code in replacing #N/A when using VLOOKUP | Excel Discussion (Misc queries) | |||
| How do I replace an asterisk without replacing everything? | Excel Discussion (Misc queries) | |||
| replacing #N/A values with zero values | Excel Worksheet Functions | |||
| Stopping autoformat when replacing cells. | New Users to Excel | |||
| XL 2003: Replacing X-Axis Labels with Custom Ones... | Charts and Charting in Excel | |||
Threaded Mode
