I wrote:
I think it would be better to convert the imported number.
You can do this by putting 100 into an unused cell and
copy it. Then select the ROI cells, right-click, and click
Paste Special Divide OK, and format the ROI cells
as Percentage. You can delete the 100.

If that seems too tedious to do every time you import data, we could show
you how to put the operations into a macro and even create a "button" to
execute the macro each time.


----- original message -----

"Joe User" wrote:
"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%.

You could use the Custom format `0.0\%` without quotes.

But I think that is a poor idea. Note that if you ever use that cell
reference in an arithmetic expression, you must remember to divide by 100
each time, e.g. =A1*A2/100, where A2 contains the number 1.3 formatted as
`0.0\%`.

I think it would be better to convert the imported number. You can do this
by putting 100 into an unused cell and copy it. Then select the ROI cells,
right-click, and click Paste Special Divide OK, and format the ROI cells
as Percentage. You can delete the 100.