printmedia
asked on
Round currency to 4 decimal places in excel 2007 vba
Hi all.
I have the code below that formats column I into currency. But instead of rounding to 2 decimal places I would like it to round to 4 decimal places. How can I do this?
Thank you in advance!
I have the code below that formats column I into currency. But instead of rounding to 2 decimal places I would like it to round to 4 decimal places. How can I do this?
Thank you in advance!
.Range("I3:I" & rng2).Style = "Currency"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.