On 20-7-2020 04:58, Mark LaPierre wrote:
You should see what Excel does to anything that looks like it could be a date. We have a field that contains text like, "01-21-34", that Excel turns into Jan 21 2034 or some other silly thing like that. There's no way to stop that from happening no matter how you format the column.We had to write a C# program to handle the data because Excel couldn't figure out what to do with it.
Your lack of understanding on how to import this data to Excel, does not make Excel a bad product.