SOLVED

Remove Comma from Number Column in Sharepoint List

%3CLINGO-SUB%20id%3D%22lingo-sub-1114098%22%20slang%3D%22en-US%22%3ERemove%20Comma%20from%20Number%20Column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1114098%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20various%20sharepoint%20lists%20that%20represent%20master%20chart%20of%20accounts%20for%20our%20financial%20systems%20general%20ledger%20codes.%26nbsp%3B%20I%20have%20set%20up%20number%20columns%20to%20represent%20a%20unique%20code%20attributable%20to%20an%20item%20(e.g.%202001%20would%20be%20assigned%20to%20Interest%20Revenue%20etc).%26nbsp%3B%20However%2C%20but%20using%20a%20number%20column%20the%20code%20defaults%20to%20appear%20as%20%222%2C001%22.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20no%20way%20to%20remove%20the%20comma%20without%20effectively%20converting%20either%20the%20column%20or%20the%20data%20to%20a%20text%20field.%26nbsp%3B%20Using%20a%20text%20field%20is%20not%20an%20option%20I%20want%20to%20pursue%2C%20as%20when%20the%20data%20is%20exported%20to%20an%20excel%20table%2C%20excel%20doesn't%20pick%20up%20the%20data%20as%20a%20number.%26nbsp%3B%20So%20when%20trying%20to%20apply%20a%20formula%20like%20vlookup%2C%20it%20will%20not%20be%20able%20to%20read%20the%20data%20from%20that%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ECould%20anyone%20identify%20if%20there%20is%20an%20obvious%20solution%20to%20this%3B%20or%3C%2FLI%3E%3CLI%3EWhere%20can%20we%20go%20to%20request%2Fpromote%20a%20feature%20or%20enhancement%20back%20to%20Sharepoint%20Developers%3F%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1114098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1118963%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20Comma%20from%20Number%20Column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118963%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521980%22%20target%3D%22_blank%22%3E%40Kruchiver%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20submit%20requests%20via%20the%20%3CA%20href%3D%22https%3A%2F%2Fsharepoint.uservoice.com%2Fforums%2F329214-sites-and-collaboration%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3ESharePoint%20User%20Voice%3C%2FA%3E.%20There%20are%20a%20number%20of%20submissions%20requesting%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENorm%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1118991%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20Comma%20from%20Number%20Column%20in%20Sharepoint%20List%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1118991%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F111382%22%20target%3D%22_blank%22%3E%40Norman%20Young%3C%2FA%3E%26nbsp%3BGreat.%26nbsp%3B%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Everyone,

 

I have created various sharepoint lists that represent master chart of accounts for our financial systems general ledger codes.  I have set up number columns to represent a unique code attributable to an item (e.g. 2001 would be assigned to Interest Revenue etc).  However, but using a number column the code defaults to appear as "2,001". 

 

There is no way to remove the comma without effectively converting either the column or the data to a text field.  Using a text field is not an option I want to pursue, as when the data is exported to an excel table, excel doesn't pick up the data as a number.  So when trying to apply a formula like vlookup, it will not be able to read the data from that column.

 

  • Could anyone identify if there is an obvious solution to this; or
  • Where can we go to request/promote a feature or enhancement back to Sharepoint Developers? 

Thanks

2 Replies
Best Response confirmed by Kruchiver (New Contributor)
Solution

Hi @Kruchiver,

 

You can submit requests via the SharePoint User Voice. There are a number of submissions requesting the same.

 

I hope this helps.

 

Norm