I'm doing a .csv file export from an application. For most of the data the Event ID is presented correctly in Excel, except those that have a "12-" prefix. I'm trying to convince the DBA that it is because of the database representation. Maybe I am wrong, but I would like to know.
The image below shows the Dec-54 and Dec-84 which should be 12-1954 and 12-2284, respectively.
I tried changing the format of the cells, but the 12-XXXX does not show up. And because I have done nothing to the other cells, which are correct, these cells should be correct as well. The Dec- values show up in the .csv file as well. In both .xlsx and .csv have the problem.