change date from 20-Mar-1920 to 20/03/1920 format
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 |
change date from 20-Mar-1920 to 20/03/1920 format
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 |
change date from 20-Mar-1920 to 20/03/1920 format
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 |
change date from 20-Mar-1920 to 20/03/1920 format
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. |
change date from 20-Mar-1920 to 20/03/1920 format
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 |
change date from 20-Mar-1920 to 20/03/1920 format
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 |
All times are GMT +1. The time now is 02:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com