I read an excel file that has a date column. All the cells in this column are formatted the same, as in the screenshot below and windows date format is dd-MMM-yy
When I read the table using read range activity, the output format is MM/dd/yyyy for one cell, the date blue rectangle below.
I need the date in dd/MM/yy format. Can someone tell how to do this, please?