Excel not saving cell and time/date formatting

[juansalix]

Hello,

I've attached a sample of my original file, since the original is too big to be uploaded. I've two main problems:

1) In my original file, values from columns B and C appear as "#####" since cell size is too small. When I autofit the column width in the format menu, the issue only solves while the file is still open. Once the file is closed and re-opened again, columns B and C will show "#####" again. For some reason, this doesn't happen with the sample uploaded. I've noticed however that the sample uploaded is a "Microsoft Excel Worksheet", while my original file is a "Microoft Excel Comma Separated Values File". Is there a way to format cell size permanently? Does the format type have a connection with my problem and if yes how to fix it?

2) As you can see on my sample, I've formated column C to have mm/dd/yyyy hh:mm. However, starting at cell C33, the format is not the same [C32: 31/07/2018 13:40] vs [C33: 1/8/2018 9:56:00 PM] although I've re-formatted the whole column. How can I get the whole column under C32 format?

Hope I was clear. Any unput is appreciated!

[TMS]

A .csv file contains data only. No formulas and no formatting.