Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Zero's, Rounding, and Hiding
Hi All,
I'm creating a spreadsheet that has some time calculations in it. The problem is that I want to hide all zero values. Now, I've already got the spreadsheet set to suppress all zeros, and I've made sure with conditional formatting and some formulas include 'zero-trapping' as well. Now, for some calculations, the sheet is returning a value of "0.00" but the REAL value of the calculation is 0.00003333. I've tried rounding the result, to no avail. I've tried setting the format to only have two digits, to no avail. This has been driving me nuts for nearly a week now. Please help!! Thanks, Ashley. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero's | Charts and Charting in Excel | |||
Hiding a button when hiding rows | Excel Discussion (Misc queries) | |||
Zero's # 2 | Excel Discussion (Misc queries) | |||
Zero's | Excel Discussion (Misc queries) | |||
Zero's | New Users to Excel |