Hi there,

I need help converting several rows of text to dates.

For example, I have several cells in column A with text 'mmm dd yyyy' (i.e. Feb 22 2011). I need to add this data to a report with several dates but obviously when I sort the data the text dates are sorted alphabetically and the dates are sorted in date order which is no good to me. I need the report all in date order.

Does anyone know of a simple formula to convert this text format (mmm dd yyyy) into a date format such 22/02/2011?

Thanking you in advance,

Matt