Hi Experts,
I am running a report, which is extracting data from csv file and Universe. I am getting the data but one of the columns from csv file is Time and it’s populating as Date format.
Please let me know what should I do?
Thank you very much.
Rob_mot 
(BOB member since 2019-01-28)
Is the data correct in the underlying csv file? If not, return to sender.
Thank you Mark,
In the csv file its showing as Time format, 08:48:38, but in BOB report’s output as Excel is showing in Date format.
Thank you.
Rob_mot (BOB member since 2019-01-28)
Have you populated it as time format or as a time string in the report?
The export to Excel is notoriously flaky - I’ve had to write scripts in the past to open an Excel file and run a vba macro to format columns! 
Much appreciated your time Mark!
The csv file’s format is as Custom. I tried to change it to time and run it again but it didn’t make any difference. I am running Macro to get the Excel output.
Thank you.
Rob_mot (BOB member since 2019-01-28)