Exploratory Community

Excel: How to prevent Currency column imported as Datetime (POSIXct) column


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.

  1. Select column menu on the import dialog and select “Numeric”

  1. Click Apply

And now you can see the Currency column is treated as numeric column.