Thanks Izandol but I still can't get it to work. I have changed them from general to a number format but still no joy. I even did a format paint from one of the columns that is working but nothing. What did you mean about chagig the data source to use Sheet2?