[SharePoint 2007] Remove Commas From Number Column Workaround

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.

John Chapman

Hello, I'm John Chapman. I am a SharePoint developer living in Mesa, Arizona. I develop solutions using ASP.NET, C#, jQuery, SQL, SharePoint, etc, and I thrive on the challenge of writing code to overcome the impossible, annoying, or otherwise difficult obstacles.

Website - Twitter - More Posts