Getting Started

 View Only
  • 1.  Remove commas (newbie here) from imported numbers

    Posted 05-20-2021 13:14
    Hello - I've spent an hour searching the community and cannot find an answer to removing the commas to my uploaded numerical column.  I was my numerical field to look like this: 123456789 not; 123,456,789

    I have changed the field properties to text and yet I still have commas.  I have uploaded twice - no workie.  Please help this new person with her first upload.  

    Thanks,

    Lois

    ------------------------------
    Lois Rockwell
    ------------------------------


  • 2.  RE: Remove commas (newbie here) from imported numbers

    Posted 05-20-2021 20:56
    Lois, I have been here a long time, but I remain a newbie too.... but try this.

    On you app, select the table that contains the data, click on settings, click on fields, click on the field that holds your numerical data and scroll down to find a section called display, that will let you set decimal places, and the next setting is display format, and there you should be able to select the format you desire.

    Hope this helps.

    Jeff

    ------------------------------
    Jeff Rogerson
    ------------------------------



  • 3.  RE: Remove commas (newbie here) from imported numbers

    Posted 05-21-2021 07:34
    Lois, if the number of digits is 12 or less, then you should be able to change this to a numeric field and set the commas not to show.

    If it is more than 12 digits, then you will need to leave it as a ext field type.

    Are you uploading from Excel?  is this a numeric field in excel or a text field in excel?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------