Skip to content
Back to formatted view

Raw Message

Message-ID: <50D20600.40504@gmail.com>
Date: 2012-12-19T18:22:56Z
From: Christofer Bogaso
Subject: Copy data from Excel

Hello again,

I my day to day calculation, I need to take lot of data from Excel and 
forth and generally I use 'clipboard' option with read.delim() function. 
However many time, the data in Excel are like '(111,000)' instead of 
'-111000'. Generally I convert data in the 2nd form in Excel itself and 
then copy to clipboard.

Is there any option in R, so that I can copy-paste '(111,000)' directly 
into R in numeric format? And also pasting data into Clipboard from R in 
the format of '(111,000)'?

Thanks for your input