How to Convert 24/03/2010 as text into 03/24/2010 date format

  • Thread starter Thread starter Nitesh
  • Start date Start date
N

Nitesh

Hi ,

I’m using Ms Excel 2003 and in my excel sheet there is a column in which
dates are entered as DD/MM/YYYY (e.g. 24/03/2010 as a text) format and I
wanted to convert it into MM/DD/YYYY (e.g. 03/24/2010).

Can excel programming is required to convert such date or is there any excel
function.

Please suggest.
 
hi
you could use text to columns
high light the date.
on the menu bar>data>text to columns
step 1 - select delimited, click next
step 2 - select tab, click next
step 3- upper right "column data format", select date.
from the drop down, select DMY, click finish.

regards
FSt1
 
Back
Top