{"id":4820,"date":"2019-11-11T14:01:34","date_gmt":"2019-11-11T14:01:34","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=4820"},"modified":"2024-02-19T14:52:38","modified_gmt":"2024-02-19T14:52:38","slug":"convert-text-to-year","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/convert-text-to-year\/","title":{"rendered":"Convert Text to Year in Excel"},"content":{"rendered":"\n
The easiest way to convert text to a year in Excel is with the TEXT<\/strong><\/a> function. It takes a value as the first argument and formatting as the second.<\/p>\n\n\n\n You can use the following formula to convert the date in Cell A2<\/strong> and display it as a year only.<\/p>\n\n\n\nTEXT(value, format_text)<\/code><\/pre>\n\n\n\n
=TEXT(A2,\"yyyy\")<\/code><\/pre>\n\n\n\n