Problem with date format

[MBjorn]

Hi,

I have generated a lot of dates by use of various LEFT()'s and RIGHT()'s, but even though they are in the correct format Excel does not recognize them.

If I double click the cells to edit them, and them press enter without doing anything, excel does recognize it as a date and formats the cell correctly.

How can I force excel to do this to a lot of cells at once?

 

[VoG]

Try this: select the dates, Data > Text to Columns, click Next twice, tick Date and select a format like DMY then click Finish.

 

[MBjorn]

Thank you for a quick answer, it works like a charm