change the display data format cell already contain data as date
 

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

change the display data format cell already contain data as date
 

Hi May this can help

press ctrl and F then click replace

and Type FIND WHAT .
in Replace with type / then click replace all

"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

change the display data format cell already contain data as date
 

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