S
Sean
How can I convert a string as 08-MAR-06 to a date in an excel cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
davesexcel
right click on mouse
select format cells
select numbers tab
select date
select the format you want
select format cells
select numbers tab
select date
select the format you want
S
Sean
I am sorry I did not make myself clear in the first post.
My cell's formular is
=CONCATENATE(MID(B3,6,2),"-",MID(B3,1,3),"-",MID(B3,10,2)), which is equal to
08-Mar-06, but it is a string. How can I make it to a date in the cell?
Thanks.
My cell's formular is
=CONCATENATE(MID(B3,6,2),"-",MID(B3,1,3),"-",MID(B3,10,2)), which is equal to
08-Mar-06, but it is a string. How can I make it to a date in the cell?
Thanks.
S
SteveG
Multiply your formula by 1.
=CONCATENATE(MID(B3,6,2),"-",MID(B3,1,3),"-",MID(B3,10,2))*1
HTH
Steve
=CONCATENATE(MID(B3,6,2),"-",MID(B3,1,3),"-",MID(B3,10,2))*1
HTH
Steve
S
Sean
NICE. Thanks.
S
SteveG
No problem