I am creating a timesheet requiring negative time to be shown in the Excel
2007 spreadsheet. I have learnt how to calculate the number of hours worked
and show how many hours have been worked over the contracted hours. This
gives a positive value.

The problem appears when the contracted hours exceeds the actual hours.
This would give a negative value but the spreadsheet shows this as a series
of ############### symbols. It will not show -2 hrs 15 min for example.

Is there a way around this problem, please.