How to change year data to its' number value

English
, , ,
#1

I have a column of dates in year format (YYYY) and want to change it to a numerical value: 2015(date format) to 2015(number format)

#2

Hallo

=YEAR(A1)
#3

Hi

If you do not want a formula, Copy then Paste As Formatted Text RTF from toolbar:

screenshot

Regards

#4

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.