Hi Peppi

One way
ToolsOptionsView and uncheck Zero values

--
Regards

Roger Govier


"Peppi" wrote in message
...
I am trying to formulate a time sheet in Excel. I have several rows of
cells
where the employee can enter in hours worked for each day. Because
othe
person in charge of time sheets doesn't want any zero values in the
TOTALS
column visible, I selected a custom format to hide the zero values.
The
problem is when I have that format selected, if the employee does put
in a
number for hours work in that row, it will total up that row, but only
puts
in a WHOLE number and will NOT put in any decimal points. So if the
employee
puts in 1.50 or 1.25, it places a 1 in the TOTALS column. I cannot go
in and
format the cell for the 2 decimal points because the custom format is
in
there. How do I get around this by hiding the zero values if there are
no
numeric info in the rows, but still have the 2 decimal places if there
are
numbers? I am very new to Excel so I apologize if this has already
been
answered. Thanks!
--
Peppi