number format for positive numbers

[Gixerstu]

Hi all,

I'm currently using the following for my number format;

#,##0 f;[Red]#,##0 \a

This is designed to give me an 'f' for favourable variances and an 'a' for adverse.

however it also gives me the f for zeros. is there a way of setting a format for positive, negative and zeros separately?

 

[VoG]

Possibly

#,##0 f;[Red]#,##0 \a;0

 

[Gixerstu]

Absolutely spot on,


thank you very much (once again)

Stu

 

[Ozas]

#,##0 f;[Red]#,##0 \a;#,##0

Works like a charm too.

Various ways of doing it mate.