Avatar of chima

asked on 

MS Excel cell value is transformed

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.
Dec-54 value
Microsoft ExcelMicrosoft OfficeSpreadsheets

Avatar of undefined
Last Comment

8/22/2022 - Mon