excel - How do I read csv with large numbers (probably scientific notation) in R? -

excel - How do I read csv with large numbers (probably scientific notation) in R? -

i have 13-digit numbers in xls file , utilize excel generate csv file because need process in r. when r read csv file, cannot recognize big numbers. example, 1329100082670 appear 1.329e+12 in r , lost precision. i've tried format big numbers text in excel , save csv didn't work!

thanks in advance!

the numbers there, default r doesn't aways show them. see

> a<-1329100082670 > [1] 1.3291e+12 > dput(a) 1329100082670

the dput() shows digits retained if display on screen in scientific notation. can discourage r using scientific notation setting scipen option. like

options(scipen=999)

will turn off scientific notation. really, looks on screen shouldn't of import hopefully.

r excel csv