how do I change format to percentage without multiplying by 100
I have imported ROI data for securities to Excel. However, when the ROI
comes over, it is formatted as 1.3, instead of 1.3%. When I try to change to
format to %, it automatically multiplies by 100 and I get 130%.
|