Convert 24/03/2010 date into 03/24/2010 date format
Hi ,
Im 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.
--
------------------------------
Thanks
Nitesh
------------------------------
|