There are no pre 1900 years when it comes to excel, it is text but you can
get it through a text function

=RIGHT(B1,4)


(excel year 0 is Jan 0 1900 thus anything before that will just be numbers
but seen as text by excel)

--
Regards,

Peo Sjoblom

(No private emails please)


"Althea" wrote in message
...
Many thanks
is there any way to get this to work on pre1900 years
Thanks
Althea
"Peo Sjoblom" wrote in message
...
=YEAR(A1)

where A1 holds the date

--
Regards,

Peo Sjoblom

(No private emails please)


"Althea" wrote in message
...
Hi
Need to get year of a date entry into a separate column, whats the
formula?
eg 2/5/1900..want 1900 in separte column

Thanks
Althea