Date format in cell differs from date format in formula bar

I am trying to upload a file into a program. The date format must be mm/dd/yy it also cannot be a text field, it must be date. The cell shows correctly but in the formula bar I am seeing mm/dd/yyyy. I have also updated my region and date settings to show short date of mm/dd/yy. I have also attached the error message I receive. Can anyone help?

Can you go through the steps you take to upload your file? - there is not much involved. I simply insert the file into the data loader and select insert.

Also, Is this the first time you've tried to upload this file? - no, I have been uploading these files/data for a few months. It just stopped working in the last few days.

What happens if you try uploading without any changes? - changes to what? I did attach the error message I am receiving. But let me know what else you may need.

If you can post the actual workbook it would also help. - attached is the file I am trying to load as well as the file with the sample error messages.

Thanks for the help!

Did you try this :

Please Login or Register  to view this content.

Or,

Please Login or Register  to view this content.

Here Text is using for formatting. But the value is Date.

Trying to upload into SalesForce Data Loader.

Yes, I did try this. The issue is that the cell cannot be text or a formula for the upload. It must strictly be a date format.