I selected the cells for August and did a search and replace. I searched for USD and replaced with nothing. Then I copied the formatting for the cells that I just did the search and replace on so that they would have the same cell formatting as the other cells in the column. I did the same thing for the column that is to the left of that column, replacing the prefix with nothing and then reformatting using the format painter. It worked well and the workbook that I uploaded has these changes.