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
Bookmarks