11

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).

13

Try to use this formula to get Year without fractions

=TEXT([Created],"yyyy")

enter image description here

Output

enter image description here

3

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

1

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]

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.