Hi,
I have written the following number formatting code for a graph:
[>1000000]$0.00,,"M";[>100000]$0,"K";$0.0,"K"
Where if it is over 1 million it will give two decimal place, if it if over 100,000 it will give 0 decimal places, otherwise it will give 1 decimal place.
I want this because I always want the data labels to be 3 decimal places.
Problem is if a value is 0 it shows up as $0.0K where I would like it to be blank.
Any ideas?
I have written the following number formatting code for a graph:
[>1000000]$0.00,,"M";[>100000]$0,"K";$0.0,"K"
Where if it is over 1 million it will give two decimal place, if it if over 100,000 it will give 0 decimal places, otherwise it will give 1 decimal place.
I want this because I always want the data labels to be 3 decimal places.
Problem is if a value is 0 it shows up as $0.0K where I would like it to be blank.
Any ideas?