Corrupt excel with dates instead values

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?

Thank you for quick response. Is it possible to copy and paste and format again to a new Excel to solve this?

I think I understood what you ment now.

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.