This code is supposed to copy the sales sheet from a sales template, paste this template onto a new sheet, check column BI for a date, and if there is a date, to delete the row containing the date and move it to the new sheet. everything seems to be working except that excel is changing the formatting of column BI from a date to a string of numbers. does anybody know why this is? thanks so much, eliasThis code is supposed to copy the sales sheet f