Hi,

I have a problem with formatting in cells not updating until I double click
into and then get out of the cell.

The cells contain data exported from Access as 7/2003, 8/2003, 9/2003 etc.
Once in Excel I am setting the cell number format as "mmm-yy". Excel seems
to recognises the data as dates but doesn't update the formatting until I
double click on the cell and click out of it.

I made sure that Calculation is set to Automatic. Pressing F9 doesn't update
the cell either. Can anyone shed some light on this?

Thanks,
Michael