How do change the symbol of cells that have format currency in euro to dollar based on cell drop list euro/dollar. Need to say that need something to apply to whole workbook that has about 700 worksheets and that sheets have cells formatted as currency, numbers and percent. So I need something that looks at value of drop list cell, then looks for cells formatted as currency in whole workbook then change symbol from € to dollar our vice versa. Don't know how to do this. The most similar thing I found was to change on a range of specific worksheet. And I need something to the whole workbook and to change only the cells formatted as currency whiteout me telling what range is.