Excel 2007 : Changing Text to YYYYt to Date

**jadelim89** · 06-18-2012, 09:46 PM

I want to change the dates to show only the year, but it won't allow me to. HELP!

01-12-2012 18:43
1/13/2012 1:00:31 PM

**vlady** · 06-18-2012, 10:36 PM

did you tried
=year(A1)

or

custom formatting yyyy

if does'nt work try Data --- text-to-column -- date
then apply formatting yyyy
maybe your dates are text so convert it to date first.

**jadelim89** · 06-18-2012, 10:41 PM

Hi

Yes I've tried all of your suggestions. The 2nd row won't budge!

It's located at the left side of the cell, whereas the 1st row is on the right. The format is General and changing formats dont work either.

Thanks!

**vlady** · 06-18-2012, 10:46 PM

the text-to-column should do it...

try this another way

Copy Any Empty Cell.
Select The Column with your dates then Format As Any Date And/Or Time Format.
While The Column Is Still Selected,
Go To Edit
Paste Special
Values
Add

another method but using another column just like above.
A1 is where the date.. then you could again paste values in the original column.
=A1+0 or =A1*1 or =--A1