Custom Number Format

Hi,

 

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:

[<1000]#,##0;[>=1000]#,##0,K

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 *