I have a list with field ActivityYear of number type. When user put an number in this field and view the number in a list view then it shows with thousand separator. For example if user put 2008 then in the view of the list it shows as 2,008. we can create a calculated column with formula =TEXT(value,fromula) function. So all I did I put the formula for the calculated field as =Text(ActivityYear,"0000")