Hi, very new to Coda 
and apologies if this is beyond basic
I have a column where the values are supposed to be percentages. Currently they are only numbers. I want to add a ‘%’ symbol to the end of each number for clarity but when I format the column to percentages the number 40 now becomes 4000% (I want 40 to be 40%). I understand why it behaves that way but I am looking for a quick work around where I don’t have to manually input the ‘%’ symbol hundreds of times.
My current approach is to create a new column with values being equal to original values * .01 and converted to percentage. And hiding the entire original column but I think this will create problems when i go to add new rows
@j_mcgill
welcome to the community ! 
% column should behave e.g. 40 should be 40%
without seeing your doc and not knowing its source- cant pinpoint but assume your source column did not divide it by 100 but it displays it as %.
anyways quick and easiest way to convert and achieve your desired end result - create another column and reference that original column / 100. then copy and paste formula column over original column.
hope this helps!
Cheers!
Mel
Hi @Melanie_Teh
(Just edited the original question a bit). There isn’t a source column, I just took an entire existing CSV file that I am hoping to enhance with CODA. So the values in the column are simply numbers (i.e 40). This number is suppose to represent a percentage, however this value was manually input and not derived from a formula.
*I see your advice!!! Thanks and I will implement that approach!
This worked–Thanks!!
1 Like