Forcing date format refresh.

[heggeman]

Hi guys,

I am sure this question has been posted somewhere, but I was unable to find it using the search screen.

I have pasted results from a database query in excel. It includes four columns with text and 1 column with a dd-mon-yyyy date format. I then changed the format of the 5th column in excel to a dd-mm-yyyy date.

However, the data did not automaticaly update to the date format. Only by doubleclicking the cell does it change. With 1000 lines of results, it means 2000 clicks..

Surely someone knows a shortcut??

 

[Andrew Poulsom]

Select all the cells with dates, choose Data|Text to Columns and click Finish.

 

[heggeman]

You're my hero.

 

[nestorkg]

Select all the cells with dates, choose Data|Text to Columns and click Finish.

Thanks, you are genius!

 

[Coffebreak]

Worked for me in 2024... 19 years later. That's what you call genius.