Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding zero values
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding zero values
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. "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding zero values
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding zero values
Thanks, Barb and Roger!! It worked perfectly! I never thought it would be
something so simple. -- Peppi "Roger Govier" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping a cell value constant trhoughout a list of values | Excel Worksheet Functions | |||
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row | Excel Worksheet Functions | |||
I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
Return Range of Numerical Values in Single Column based on Frequency Percentage | Excel Worksheet Functions | |||
Hiding repeated values | Excel Discussion (Misc queries) |