'Expecting numeric Error while importing data

while I try to import my dataset from excel on R using readxl::read_excel, I receive this error:

1: In read_fun(path = enc2native(normalizePath(path)), sheet_i = sheet,  ... :
  Expecting numeric in K14 / R14C11: got a date

Repeated for more than 50 times! Can somebody help figure out why this is happening? Thank you all



Solution 1:[1]

This occurs when you have different variable types in the same column. You can always use the coltypes='text' option to get stuff imported and then sort it in R.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 tricky999