Pages

Monday, August 18, 2008

Thousand separator in SharePoint field item

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

1 comment:

  1. If you really need the image/color option in dropdown then another option might be to develop custom webpart for the pages where u need the image/color functionality. In that webpart, you can implement the functionality. However, whether u'll use the built-in control (like in the link u provided) or develop custom webpart, depends on the situation u r in.

    ReplyDelete

Note: Only a member of this blog may post a comment.