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.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…