I am trying to insert data from a data table into excel, but the data format is being changed automatically.
The problem occurs when the data is exactly “24:00” then it is transformed to “1/1/1900 12:00:00 AM” in Excel.
When the data is anything else like “0:09” then the format is preserved as “12:09:00 AM”
The data table is set to type “string”, which apparently is not recognized in Excel where it is transformed to “Custom”
Can someone help me in solving this issue?