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.

About the author

I work with customers helping them achieve more using Microsoft Technologies. I am in my 9th year with Microsoft as of March 2020. I get to work with really smart people (both at Microsoft and Customers). Helping customers, removing any blockers, rapid prototyping is my core work.