software

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

Format those cells to allow 2 decimal places by default
For the conditional format, put something like this in:

Cell value is equal to 0.
Make the background the same as the standard background and match the font
color to it.

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

One way
Toolsgt;Optionsgt;View and uncheck Zero values

--
Regards

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

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