change the display data format cell already contain data as date

  • Thread starter Thread starter Harun
  • Start date Start date
H

Harun

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
 
Hi May this can help

press ctrl and F then click replace

and Type FIND WHAT .
in Replace with type / then click replace all
 
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 Next>Next 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.
 
Back
Top