Try this:

With
A1: 14FEB2005
B1: =--A1

OR...you can use Text-to-Columns and set that cell's data type to Date: DMY

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

XL2002, WinXP


"MIchel Khennafi" wrote:

> Good morning Gurus
>
> I have a cell into which the following string is entered "14FEB2005"... This
> is a value extracted from a file. This is currently being handled as a text
> by Excel. What could be the formula I need to transform this value into a
> date like "14-feb-2005" and have it treated like a real date?
>
> I tried to use Date (mid(),mid(),mid()).. but got an error for the month
> conversion... Any other suggestion?
>
> Thanks a lot
>
> Michel
>
>
>