Format numbers

[Viking08]

I have a spreadsheet and need to reformat the numbers. I want the number to be a "-" if it is 0. Normally this is not a problem becuase I can format it as accounting. But this is not helping this time. Is there a way I can do this through custom formating?

 

[AussieRob]

the easy way to do this is Ctrl. F.

Then instead of find use replace. Replace all 0's with ="-".

Done

 

[Brian from Maui]

For Custom formatting try,

0;0;-

 

[Oaktree]

Your values may be rounded.

0.00001 formatted to 0 decimals will show 0 and not -.

 

[VBA_Newbie]

If you need to use those cells in calculations, you might find this handy. I had dashes in my cells which represented 0. When I needed to use those cells in calculations in other places in my procedure I needed to treat the value of the cell "-" as 0. So I wrote this bit of code. So the variable x2 represents the value of the selected cell. If the value is "-", then I tell it to make x2 = 0. If it's not "-" then x2 is equal the number in that cell.

Dim Catchdash As String
FormatRange.Cells(i, Col2Num).Select
Catchdash = Selection.Value
If Catchdash = "-" Then
x2 = 0
Else
x2 = Selection.Value
End If

Who knows, you might find it handy. If not, oh well.

So if you nee