I have saved a file from quickbooks into excel. when I open the report, the
dates in my transaction date column are in text format. When I change the
column to date format, nothing happens until I double click in each cell. It
is as if I have to enter the cell and leave it to 'activate' my command to
change date formats.

this will not do of course, because I have thousands of rows. how do I get
them to all update when I change the format?