My formula is based on subtracting the value of 2 different cells. If no data
has been entered into one of the cells then I get the #value! result. How can
I either hide this or display it as some meaningful text. Can I use
error.type?


"Nick Hodge" wrote:

Min

Widen the column or do not try and display negative times

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog: www.nickhodge.co.uk/blog/

FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007
www.officeusergroup.co.uk

"Min" wrote in message
...
How do I stop ##### from displaying in formula cells?