Remove the % symbol in field without changing it to Numeric

Question

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

AdamKeever1 · Answer

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

Sign up

Login to the community