Hello
I got several Excel files, that had dates instead laboratory values and indexes. All other files (nped.csv) turned out correct to RStudio while importing with Rio package. But the last one, .csv has many cells with dates like 22.May instead values. I tried to repair it in Excel without any success. Is there a way for me to get the correct values back?
If the files are of type .csv, any date formatting would have to be applied by Excel. Perhaps the file was opened and saved with formatting before the data were imported? Is it possible to recreate the .csv file?