when i pull up the report sometimes text values appear because of invalid values or calculations such as "#NUM!" AND "#DIV/0!".
i don't want to confuse the user who is pulling up this report. i want to replace these text to my own personal text. is this possible.
for example, if #NUM! appears i want it to have a value of 0.
if anyone can help i would be greatful. thanks to all in advance.
i don't want to confuse the user who is pulling up this report. i want to replace these text to my own personal text. is this possible.
for example, if #NUM! appears i want it to have a value of 0.
if anyone can help i would be greatful. thanks to all in advance.