Forum Discussion

NikkiWalters's avatar
NikkiWalters
Qrew Cadet
6 years ago

Remove the % symbol in field without changing it to Numeric

I need help removing the % symbol and adding additional digits in several Percent fields.  As it should, when I change the display options to simple number or change the field type to numeric it changes the format to .0125.   I need the number to stay as 1.25 and appear as a 5 digit number.  So, 1.2500 and 0.6750.

At a loss for an solution other than reformatting all my data & re-importing.  


------------------------------
Nikki Walters
------------------------------
Formulas and functions
Tables and fields
  • AdamKeever1's avatar
    AdamKeever1
    Qrew Commander
    6 years ago
    Changing the decimal places to 4 will fix the number of digits:


    I don't know of a solution for the other issue other than for you to download as a spreadsheet, make a quick formula to multiply your value by 100 and then copy that column and paste values, then import using the Record ID# as the merge field; this will update only the values you have changed and will overwrite the old values.


    ------------------------------
    Adam Keever
    ------------------------------
    • AdamKeever1's avatar
      AdamKeever1
      Qrew Commander
      6 years ago
      I thought about this a bit more Nikki. You can use a formula numeric field with the following formula:

      [YOUR_PERCENT_FIELD] * 100

      Set display properties to 4 decimal places and display as a simple number:

      Here is the result:

      If you change the formula numeric field type to numeric, it will retain the values.


      ------------------------------
      Adam Keever
      ------------------------------