Ask Your Question
0

how to change year data to its' number value

asked 2016-10-14 22:43:18 +0200

zardoz199 gravatar image

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)

edit retag flag offensive close merge delete

Comments

Hallo

=YEAR(A1)
karolus gravatar imagekarolus ( 2016-10-15 00:29:29 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2016-10-15 14:56:15 +0200

pierre-yves samyn gravatar image

updated 2016-10-15 14:56:50 +0200

Hi

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

screenshot

Regards

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-14 22:43:18 +0200

Seen: 53 times

Last updated: Oct 15 '16