Frustrated with cell formatting

  • Thread starter Thread starter RzB
  • Start date Start date
R

RzB

Hmmm... have been tearing hair out....

I want the following cell formatting to
occur but I just can't figure it out.

If the value is zero - I don't want to see
anything. However I don't want to turn
zero's off at the sheet level because there
are other places that I do want zero to appear...

If the value is 1 then I want to see 1 - no decimal places...

if the value is less than one I want to
see 0.3 (for example) - one decimal place with leading 0.

if the value is greater than 1 I want to
see 1.3 or 2.0 (for example) - one decimal place
with leading 0

NB - the numbers will never be negative

Any help would be appreciated and may just save my hair,
what's left of it :-)

Thanks,
Roy
 
Format|Cells|Number|Custom
in the Type box put the following formula

[=1]General;[White][=0]General;0.0

This assumes that the background is white, otherwise change the color
appropriately so that 0's will be the same color as the background.

Jerry
 
How about formatting exactly as this:
General;General;
OR
General;;
(given you said it'll never be negative)
(trailing semicolon(s) required)
 
Bob/Jerry,
Many thanks for your help. I think I understand a little better now...
Hair saved!
Thanks,
Roy
 
Back
Top