When you try to import the Excel sheet that contains a Currency column like below,
You might end up seeing the column as treated as POSIXct column like below in Import Dialog.
To import this column as numeric, you can change the data type as follows.
- Select column menu on the import dialog and select “Numeric”
- Click Apply
And now you can see the Currency column is treated as numeric column.