Date format changing in some cells after reading and writing range

[Aaronlim]

hi,

in one of my sequences, i used a read csv activity followed by a write range activity in an excel application scope, and this was the result.

right pic is the csv file that was read from, and left pic is the bot output after writing range. As seen, some cells have the date format switched to mm/dd/yyyy. How can i fix this?

thanks

[supermanPunch (Arpan)]

@Aaronlim Can you use this Activity to change the Column type of that Column to DateTime and Check if it gives the right output ?

UiPath Marketplace | Error

[Aaronlim]

hi,

im using my work laptop which cannot connect to the internet, so i cant download custom actvities