I thought this article was a brilliant workaround and wanted to share. It was original posted over at:

http://sharenotes.wordpress.com/2010/05/11/workaround-format-sharepoint-number-column-to-remove-commas/

Let¢€™s say you have a column named “TicketNumber” of number type in your list. By default SharePoint formats it to show with commas. If your requirement is not to show those comma¢€™s then here is a workaround.

Create another column of “Calculated” column type and set the formula as follows:

=TEXT(Original_Number_Column_Name,¢€0¢€³)
Ex: =TEXT([TicketNumber],¢€0¢€³)

And then use the calculated column in place of your original column for display purposes.


Pin It on Pinterest

Share This
%d bloggers like this: