Convert General to Date

[RRA23]

Hi, I have in cells such as:
20010228
and i need to convert it to date format, such as:
02/28/2001

can anyone provide some advice?

thanks,
RRA

 

[dk]

How about this?

=DATEVALUE(MID(A1,5,2) &"/" &RIGHT(A1,2) &"/" & LEFT(A1,4))

HTH,
D

 

[Mark W.]

On 2002-03-14 11:09, RRA23 wrote:
Hi, I have in cells such as:
20010228
and i need to convert it to date format, such as:
02/28/2001

1. After selecting the cells containing your values choose the Data | Text to Columns... menu command.
2. Press [ Next > ] until you reach Step 3 of 3 where you'll click the 'Date' radio button and pick YMD from its drop down list.
3. Press [ Finish ].