[R] How to calculate values with percent sign imported from Excel?

Peter Ehlers ehlers at ucalgary.ca
Thu Jun 21 18:47:49 CEST 2012


On 2012-06-21 06:19, David Winsemius wrote:
>

[...]

> What you should have done was convert the Excel column to numeric from
> percentage using the "Format/Cell" menu and then import.

This is excellent advice.
It has been my experience that _very_ few Excel addicts
are aware that columns in their spreadsheets can be 'typed'.
Much data transport grief can be avoided by doing so.

Peter Ehlers



More information about the R-help mailing list