 We want to change the format of the sales and cost of goods to currency. Go to the home tab, then the number section, and then the drop-down window, open the number format, and select currency. That gets us almost there, but we don't want the trailing to zeros. So let's remove those. Go to the decrease decimal section, double-click to remove both decibels, and that gets us where we want to be. Now let's copy that format down, click on the format painter, get the paintbrush, and drag it down to select all the cells that you want to copy that format to. Release it, and you have the cells formatted. Remember that formatting doesn't change the underlying number. Excel keeps original number.