Formula / conditional formatting for cell value in MS Excel

Question

Here is my question? I have an excel worksheet, where inputs are fed by me in the cells. I have a typical situation. When the input value is 0.0, it should show as -- instead of 0. Say in cell B4, I enter a value 0.0, it should show "--". Neither if formula nor conditional formatting helps me here. Any suggestions?

Answer 1

format cells -> Custom -> #,##0.0 ; -#,##0.0 ; --