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?
1 Answers
Related