how do I change format to percentage without multiplying by 100
1.3 is 130%. The same way 0.5 is 50%. You are best off to divide your numbers
by 100 and formatting those. You could do a custom format but to use the
value in a calculation you will have to divide it by 100 anyway.
--
HTH...
Jim Thomlinson
"Fdn Girl" wrote:
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%.
|