Try this:

Select your range of "dates"

From the Excel main menu:
<edit<replace
Find what: ~'
Replace with: (leave this blank)
Click the [Replace All] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"SSJ" wrote:

Hello!

When I download data into excel some of the dates in the data comes as:

2Sep'06


I edit the cell by taking out the apostrophe and the value becomes a date. What formula / function can I use to take out or clean this apostrophe and make it a date?

Thanks
SJ