I am reading a csv file into a datatable. The datatable comprises of 4 columns each of type string. One of the columns reads a date from the csv file in format dd/MM/yyyy.
When I write the resulting datatable to the output screen the column displays as 08/05/2017 as expected however when I write the datatable to excel it becomes 42953 (the date in number format).
if I cut the output of the write line and paste it into excel manually I don’t get the same issue. The date remains as a string. The conversion seems to occurs during the write range step.
What steps do I need to take to ensure the write range maintains the date string in its same format?