I use round() to round off in R and works fine but when I export DF to excel (workbook) and open the files in excel it shows all digits!
round should change the values, but this does not happen in place. For example, if
x is a vector with values before rounding,
round(x) will show you rounded values, but
x is unchanged so far unless you do
x <- round(x). If you missed this assignment, that may cause your issue.
If that is not the case, can you please share a reproducible example? If you're not familiar, please go through this FAQ: