I am having problems with a file of Excel worksheets.
I have almost 11 months of data with one Excel file per workday.
Within the worksheet I have a column of Dates. All of these are in this format: _(* #,##0_);_(* (#,##0);_(* "-"??_);_(@_)
While I was attemting to pull all these excel files in I found out that all the files from March had incorrect dates for the last four days in the date column the Year increased by one each time. When I had the creator of these files go in and fix this problem now all of March shows up as Numeric (3/1/2023 = 44986). I have not been able to figure out how to get everythingin that column to line up as a Date. I have changed the column from General to Number, then to date. I've tried from General to Text to Date, no luck. I've tried about every combo I can think of.
Before I go back to the Creators of these files and tell them they have to make alllll the rest of the Date columns like they did with March, I was hoping that someone out there could provide me with some help.
