For a POC for a client, we need to append a message to an input excel file in the case that the file is rejected by the bot. However, when this happens the date format (which needs to remain in a very specific format) is ruined.
Here is an example:
Take this column of dates before running the bot -
Then immediately after running -
which is obviously, completely broken. But after clicking in the box on excel it corrects to
which, while readable, is still a change from the proper date format.
What can I do to fix this?