Remove the number format in the sheet
Posted on 2016-08-25
I need to remove the number formatting applied to the sheet but only for the cells that have $- as a format.
example: I have a sheet that has many cells with $ - (meaning 0) and I want to avoid removing the format of each individual cell as that would be timely. I just simply want nothing in the cell (no currency sign or dash). I want to keep the cell coloring though.