Wednesday, July 11, 2012

Remove comma from number field using Lookup column

In Sharepoint if we create a column having type Number then the item will display with comma as for example year 2,000.But this can be resolved just by adding a lookup column in the list.here described step by step.


Step 1. Create a list




Step 2. Select List and create custom list



Step 3.Create a list of Name TestYear and Select List setting



Step 4.Create column named Year and select type number



Step 4
.Create Calculated column named CalcYear as setting CalcYear(=Text(Year,"0"))

Now you can add items in Year column and List will display as below.You can also use this in CAML Query as well in programming

No comments:

Post a Comment