Not showing 0.0 on a chart

[Peter Davison]

I have a pivot chart and I read somewhere that if you use #.#"" as a custom number format it will remove zero's from the data labels.
The problem with this it removes pre and leading zero's so 0.6 would become .6 and 2.0 would become 2.
Is there a different customer number format other than #.#"" that would give me a display to one decimal point but keeping zero's if they were above 0.0
Any help would be great

 

[RoryA]

The third section of a custom number format is the section for 0, so it would be:
0.0;-0.0;;

to hide zero values but that will only work if the actual values (not just the rounded ones) are 0.

 

[Peter Davison]

Thank you I will try this in the morning and let you know how I went on.