hi,
what format are you using now?
####### could also mean that the column is not wide enough.

-----Original Message-----
I am having trouble formatting a cell so that when the
number of hours
someone has completed for work against what they should
have worked can show
as a negative value instead of
#############################.
.