Hi Nitesh,

Because you say the dates are entered as text you can use Text to Columns to
change it to a real date and it should format the cells as dates.

Select the column with the text dates.
Select menu item Data - Text to columns - Fixed width - Next - Next- Date
At the Date dropdown select the date format that it is in currently ie. D/M/Y
Click finish.

The date will now be in your regional date format and the cell formatted as
Date. Now you can re-format the date using Number format to any format you
want.


--
Regards,

OssieMac


"Nitesh" wrote:

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
------------------------------