Have a look at Excels help regarding the function: ISERR
Micky


"trotterpig" wrote:

When a cell returns the text #VALUE!, how can I convert this to read the
number 0?