Import read_excel without all decimals

I am importing a sheet from excel. My data has more than 10 decimal places, however, when I import the data into R, using read_excel(), the numbers have only 5 decimal places. When I compare the calculations between Excel and R they are different because in R I have only 5 decimal places.

Why can this happen and how can I fix it to import the values with all decimals?

Thank you.

set options(digits = 20) should work.
Change 20 to a larger number if the decimal place is larger than 20.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.