Forum Discussion

RJF61's avatar
RJF61
Copper Contributor
Aug 02, 2024

Field Type Modification

I performed an import of Excel data into SharePoint List.  I brought the Excel (ID) field into the Title column.  I need this to be sortable so I created a Numeric column (IDMaster) with the values from the Title column and there are over 1000 records.  How do I format the IDMaster so that it does not include a "," (i.e., 1,000 -> 1000)?  

SharePoint Server
  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor
    Aug 05, 2024

    RJF61 once you've copied all the items from the text column to number column, edit the number column, go down to More options and change the Use thousands separator toggle to no. 

     

     

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)