I have many cells which are in a text format of July 15, 2008. I have updated the cell format to that of date so that it will read as 7/15/2008. However, this update is not reflected in the cell until I "click in" the cell itself (F2). This is frustrating as I need to have this update show for thousands of cells. How do I get excel to see this format change?