Custom format question

[PATSYS]

How do you make a custom cell formatting wherein if there is figure, it will expressed in % but if the value is zero, then it will just show "-".

 

[pgc01]

HI PATSYS

Please try

0%;-0%;"-"

Hope this helps
PGC

 

[Richard Schollar]

Something like:

0.0%;-0.0%;"-"

Best regards

Richard

 

[GlennUK]

Custom number formats come in 4 parts, separated by the ";" character ...

format_for_positive_number;format_for_neg_number;format_for_zero;format_for_text_entries

 

[PATSYS]

Thank you all for the very useful info.