Re: [R] Read in alphanumeric column without decimals

2012-11-29 Thread Steven Ranney
Thanks for the replies. I hadn't considered changing the original spreadsheet to a table as there are several different analyses using the .xlsx spreadsheet that contains the alphanumeric data, thus requiring an alteration of all of our code. However, the first response did prompt me to try chang

Re: [R] Read in alphanumeric column without decimals

2012-11-29 Thread jim holtman
Your problem is the the data read in from the spreadsheet is probably a 'factor' since it has a non-numeric in the column. To change it to number you have to do the following as.numeric(as.character(yourdata$TeamLeaderID)) What you as seeing with just the call to as.numeric is the value of the '