List

A

Arne Hegefors

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!
 
R

Roger Govier

Hi

In B1
=A1
Format>cells>Number>Custom> yyyy
Copy down

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