What formula are you using that returns ##### for negative values? How is
the cell formatted which returns #####?

Dave
--
Brevity is the soul of wit.


"msiz" wrote:

hi
I have managed to set up a timesheet (all by myself woohoo!!). Having a few
problems though!
I have a rolling timesheet over a 4-5 week period. It adds up the daily
total no problem, but for the daily difference, if it is a negative then it
shows up as ######.
anyone any ideas?
thanks
msiz (",)