Putting dashes where there are 0's

  • Thread starter Thread starter Rod
  • Start date Start date
R

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.
 
Hi Rod
try this: in C5
=IF(ROUND(B5,-3)=0,"-",ROUND(B5,-3))

where B5 is your original data

Mathew
 
Hi Rod Try this in C5

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

Where Original Data in B5

Mathew
 
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
 
Back
Top