How to refresh all the cells in a column after changing the formatting?

[The_Snook]

Hi,

I've been given some data and the date column is formatted as 'general'. If I amend it to the date format I prefer and click ok nothing changes. If I then click in the cell and press enter it changes the format to what I want. Is there anyway of refreshing all the cells so the format change takes effect?

I can achieve what i'm after by using find and replace to change '2012' to '2012' and '2013' to '2013' but i'd be interested to know whether there is a more recognised solution?

Thanks,

Snook

[Andrew-R]

Does pressing F9 to force a recalculate update the cells?

[The_Snook]

I think it only works on cells that contain formulas, not raw data that has had its format changed?