View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nitesh nitesh is offline
external usenet poster
 
Posts: 11
Default 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
------------------------------