You can use the 'Convert Text to Columns Wizard to convert the dates

--Select the range of dates which needs to be corrected.

--From menu Data'Text to Columns' will populate the 'Convert Text to Columns
Wizard'.

--Hit NextNext will take you to Step 3 of 3 of the Wizard.

--From 'Column Data format' select 'Date' and select the date format in which
your data is (DMY)

--Hit Finish. MSExcel will now convert the dates to the default date format
of your computer.

--
Jacob


"Harun" wrote:

In Excel sheet a column contains datas as like 19.12.2008 this column
contains"General" format. Now I want to change and display above as date
format like 12/19/2008