I have a report, which I download on a daily basis, however, the date in column A is in a text format and shows the date in the format 20100427.

Is there anyway that I can convert this date so it shows as a date and in format DD-MMM-YYYY so today would be 27-Apr-2010