Putting dashes where there are 0's

[Rod]

I have a custom format that is rounding to thousands. I would like to
be able to put dashes in the fields that are showing 0(meaning that
there is a number but it is less than 500). This i probably easy for
some of you all.

 

[Mathew P Bennett]

Hi Rod
try this: in C5
=IF(ROUND(B5,-3)=0,"-",ROUND(B5,-3))

where B5 is your original data

Mathew

 

[Mathew P Bennett]

Hi Rod Try this in C5

=IF(ROUND(B5,-3)=0,"-",ROUND(B5,-3))

Where Original Data in B5

Mathew

 

[Bernard Liengme]

In a custom format, the third item specifies the format for zero values.
This gives numbers to nearest thousand with dashes for low values:
##,;-##,;"--"
Best wishes
Bernard