LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 71
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Zero's Bar Charts With =sum ... showing Zero Charts and Charting in Excel 1 December 7th 06 07:02 PM
Hiding a button when hiding rows fergusor Excel Discussion (Misc queries) 2 August 10th 06 02:31 PM
Zero's # 2 Delaina Excel Discussion (Misc queries) 3 October 24th 05 08:02 PM
Zero's Delaina Excel Discussion (Misc queries) 2 October 20th 05 06:38 PM
Zero's Krandall New Users to Excel 1 June 9th 05 08:11 PM


All times are GMT +1. The time now is 02:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"