Hi all,

I want to copy a column from one worksheet into another and show it as percentage.

I used the following formatting

ws2.Cells(y, 5) = Format(ws1.Cells(i, 4), "0.00%") or
ws2.Cells(y, 5) = Format(ws1.Cells(i, 4), "Percent")

which turns 0.193360991761599 into 19.34% which is fine, but it rounds it to decimal places and removed everything after that.

Do you know how to keep the format showing as 19.34%, but the value show all decimal places?

Regards