Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Jeff Newmiller
_______ >De : Jim Lemon >Envoy� : mercredi 30 ao�t 2017 15:00:32 >� : Nelly Reduan; r-help mailing list >Objet : Re: [R] Converting character to numeric using the package >"XLConnect" > >Hi Nelly, >Are you trying to convert hexadecimal to decimal? > >

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Jim Lemon
10,1]) ## Problem: must be numeric > > [1] "1" > > Thanks very much for your help. > Nell > > -- > *De :* Jim Lemon > *Envoyé :* mercredi 30 août 2017 15:00:32 > *À :* Nelly Reduan; r-help mailing list > *Objet :* Re: [R]

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Nelly Reduan
<- strtoi(set[index]) > print(set[10,1]) ## Problem: must be numeric [1] "1" Thanks very much for your help. Nell De : Jim Lemon Envoy� : mercredi 30 ao�t 2017 15:00:32 � : Nelly Reduan; r-help mailing list Objet : Re: [R] Converting cha

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Jeff Newmiller
nvoy� : mercredi 30 ao�t 2017 12:59:57 >� : Nelly Reduan >Cc : r-help@r-project.org >Objet : Re: [R] Converting character to numeric using the package >"XLConnect" > > >> On Aug 30, 2017, at 12:24 PM, Nelly Reduan >wrote: >> >> Hello, >>

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Jim Lemon
Hi Nelly, Are you trying to convert hexadecimal to decimal? nrdf Setting Value 1 Parameters a 2 Parameters b 3 Parameters c 4 Parameters d 5 Parameters e 6 Parameters 2 7 Parameters 8 8 Parameters 9 9 Parameters 7 10 1 a 11

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Nelly Reduan
via OneDrive Thanks very much for your help. Nell De : David Winsemius Envoy� : mercredi 30 ao�t 2017 12:59:57 � : Nelly Reduan Cc : r-help@r-project.org Objet : Re: [R] Converting character to numeric using the package "XLConnect" > On Aug 30, 2017,

Re: [R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread David Winsemius
> On Aug 30, 2017, at 12:24 PM, Nelly Reduan wrote: > > Hello, > > From an Excel file imported into R where each cell contains characters, I > would like to convert some characters to numeric. However, my code doesn’t > work. When I write data to worksheets in an Excel file, some numbers in t

[R] Converting character to numeric using the package "XLConnect"

2017-08-30 Thread Nelly Reduan
Hello, >From an Excel file imported into R where each cell contains characters, I >would like to convert some characters to numeric. However, my code doesn’t >work. When I write data to worksheets in an Excel file, some numbers in the >cells are stored as text (instead of numeric). Here is my c