Hi

In B1
=A1
FormatcellsNumberCustom yyyy
Copy down

or
=TEXT(A1,"yyyy")
and copy down

--
Regards

Roger Govier


"Arne Hegefors" wrote in
message ...
Hi! I have a long list of dates in column A. IN col B I want to have
only the
year of the date in column A. The date is written like: YYYY-MM-DD.
How can I
get only the year? Thanks alot!