I am trying to write code that would look in column A in the excel workbook (it is a text field with descriptions) if there a is a % in the description then format the 12 cells to the right as percent. and continue to identify all the data that has a % in column A.