C
Confused
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
the date format dd//mm/yyyy 20/03/1920
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jacob Skaria
Try the below
--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.
If this post helps click Yes
--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.
If this post helps click Yes
C
Confused
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.
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.
A
arjen van...
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.
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.
J
Jacob Skaria
From the 'Text to Columns' Wizard you would have probably selected a
delimiter. Dont select any delimiter in Step 2. Just hit Next>Next to reach
the 3rd step
Or
In step 1 select as Fixed width and skip Step 2.
If this post helps click Yes
delimiter. Dont select any delimiter in Step 2. Just hit Next>Next to reach
the 3rd step
Or
In step 1 select as Fixed width and skip Step 2.
If this post helps click Yes
C
Confused
Thanks .it works.
Jacob Skaria said:From the 'Text to Columns' Wizard you would have probably selected a
delimiter. Dont select any delimiter in Step 2. Just hit Next>Next to reach
the 3rd step
Or
In step 1 select as Fixed width and skip Step 2.
If this post helps click Yes