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
Bookmarks