select the column
<data<text to column
<delimited<next<next
<date then either MDY or DMY depending on whether the date is to month day
or day month
<finish


"Natalie" wrote:

Hi all,

The dates in my column are preceded by and apostrophe. Anyone knows a quick
way to get rid of the apostrophe. I have about 3000 rows on the spreadsheet.

This is how the date appear

€˜ 04/05/2007

To get rid of it I back space or delete the apostrophe.


Thanks for your help!