I am new to SharePoint and I am trying to display year with the help of calculated column. However, the resulting year is displaying with comma i.e. 2,016 instead of 2016.

Is there any easy way of changing it. I have given the formula =YEAR(Created).


Try to use this formula to get Year without fractions


enter image description here


enter image description here

| improve this answer | |

Looks like you have set the datatype of the Calculated Column output to Number instead of String (Single Line of Text)

| improve this answer | |

There's one more easy way: if it's not a date and you don't know how many digits you'll need, just concatenate your number with an empty string like this:

= "" & [NumericColumn]

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.