OK, I found another piece to the puzzle. The code to change the number format works if I don't have the worksheet with the problem cells selected. If I am viewing the worksheet when the Clock procedure fires then the problem cells change back to the Date format

I would really appreciate any further suggestions on how to solve this problem.