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.
