MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing Date Format


Posted by Bob on December 18, 2001 11:03 AM

How do you change the date from mm/dd/yy to yyyy? I'm sure that this is pretty simple, but it's got me whipped.


Posted by Aladin Akyurek on December 18, 2001 11:08 AM

Activate Format|Cells|Custom then select mm/dd/yy or something similar and change it to the desired format.

Aladin

Posted by Bob on December 18, 2001 11:15 AM

The format option did not work. Is there a wildcard that I can use in Find & Replace that will look for every cell containg **/**/96 and replace then with 1996? I tried asterisks and question marks, but neither one worked.

Posted by Aladin Akyurek on December 18, 2001 11:22 AM

Bob --

It works for me.

Try again. Select a date format and change it to yyyy in the box for "Type".

Another option is:

Insert another column next to your dates column.

Lets say that you have dates in A from A2 on.
In B2 enter: =YEAR(A2) and copy down as far as needed.

Select all of the cells of B, copy the selected range, and execute Edit|Paste Special ->Values in place. Delete column A.

Aladin

Posted by Bob on December 18, 2001 11:26 AM

Thank you for your help.