VBA NumberFormat

[Dimitris254]

is there a way to combine the following two commands in one?

Sums_range.NumberFormat = "[>=1000]#'##0;0"
Sums_range.NumberFormat = "0;-0;-"

the first formats numbers in the 0'000 format (with tone for thousands) and no decimals

the second formats zeros to dashes

 

[BiocideJ]

I think this is basically what you are looking for.

Sums_range.NumberFormat = "#'##0[>=1000];-[=0];0"

 

[Dimitris254]

Thank you, sir