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

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

Michel,

If your text is in A1 then

=VALUE(A1)

Format as Custom dd-mmm-yyyy.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=563359

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

Hi Michel

Not that it's any better than the other posts but also:

=DATEVALUE(D3)

Regards

Steve