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 ...
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
------------------------------