Custom Number Format



I have been trying to create a custom number format for the following criteria:


1) IF less then 1000, display number as 3 digits (i.e. 100, 450, 999)

2) IF greater then 1000, display number in thousands with the metric prefix “k”

3) IF zero then show as “-“


In this case I wont encounter negative numbers.


I can manage to get criteria 1 and 2 to work, with the number format:


Howver, I can’t find convert all zero values to “-“


Can anyone offer any advice? Can what I ask be done?

By: John

Leave a Reply

Your email address will not be published. Required fields are marked *