How well do you Excel?

User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

How well do you Excel?

Post by Rudi »

How would you achieve this in Excel?
  • 1 Hide all zero values on a sheet
    2 Hide zero values in selected cells
    3 Display hidden zero values in selected cells
    4 Display zero values as dashes
    5 Hide zero values that are returned by a formula
    6 Hide zero values in a PivotTable report
    7 Add a leading zero on a three digit code
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
User avatar
Bowlie
5StarLounger
Posts: 1051
Joined: 26 Jan 2010, 17:08
Location: Confoederatio Helvetica

Re: How well do you Excel?

Post by Bowlie »

Hi Rudi!

Really it's quite simple:
Spoiler
I'd ask Hans! Clever Clogs himself
:cheers:
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: How well do you Excel?

Post by Rudi »

:rofl: I'd probably do the same. :cheers:
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top

Return to “Scuttlebutt”