How do I change the date if it is written in general format as 20-Mar-1920 to
the date format dd//mm/yyyy 20/03/1920

Try the below

--Select the range of dates which needs to be corrected.
--From menu DataText 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.


If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

How do I change the date if it is written in general format as 20-Mar-1920 to
the date format dd//mm/yyyy 20/03/1920

I used the convert text to colum wizard. It split the data into three columns
but I can't combine it to get 20/03/2009. I used =DATE(Year,month,Date) and I
get an error display not the date I am looking for.

"Jacob Skaria" wrote:

Try the below

--Select the range of dates which needs to be corrected.
--From menu DataText 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.


If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

How do I change the date if it is written in general format as 20-Mar-1920 to
the date format dd//mm/yyyy 20/03/1920

If you're simply trying to format the dates in one column, go to Format Cells
and on the Number tab choose custom. In the box where it says type enter:
dd/mm/yyyy. Hit enter and you should be ok.

From the 'Text to Columns' Wizard you would have probably selected a
delimiter. Dont select any delimiter in Step 2. Just hit NextNext to reach
the 3rd step

Or

In step 1 select as Fixed width and skip Step 2.

If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

I used the convert text to colum wizard. It split the data into three columns
but I can't combine it to get 20/03/2009. I used =DATE(Year,month,Date) and I
get an error display not the date I am looking for.

"Jacob Skaria" wrote:

Try the below

--Select the range of dates which needs to be corrected.
--From menu DataText 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.


If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

How do I change the date if it is written in general format as 20-Mar-1920 to
the date format dd//mm/yyyy 20/03/1920

Thanks .it works.

"Jacob Skaria" wrote:

From the 'Text to Columns' Wizard you would have probably selected a
delimiter. Dont select any delimiter in Step 2. Just hit NextNext to reach
the 3rd step

Or

In step 1 select as Fixed width and skip Step 2.

If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

I used the convert text to colum wizard. It split the data into three columns
but I can't combine it to get 20/03/2009. I used =DATE(Year,month,Date) and I
get an error display not the date I am looking for.

"Jacob Skaria" wrote:

Try the below

--Select the range of dates which needs to be corrected.
--From menu DataText 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.


If this post helps click Yes
---------------
Jacob Skaria


"Confused" wrote:

How do I change the date if it is written in general format as 20-Mar-1920 to
the date format dd//mm/yyyy 20/03/1920