Column format Change

[supermanPunch (Arpan)]

@Shashi123 ,

Give a first try by Enabling the PreserveFormat option in Read Range activity and perform the remaining actions.

We can then check with the Format Cells activity if you are comfortable in using the Modern Design activities.

DateTime.ParseExact the whole Column without looping

Hi @arthurang , If the Target Goal for you is to represent the dates in Excel Sheet Column in MM/dd/yyyy format, maybe you could use the Format Cells Activity if you have the latest versions in place. [image] You would require to know which column the Date column is present (A or B or C, in my case it is J), then we can use the Range as J:J. If we do not know the position of the column in the Excel sheet too, we can dynamically be able to find it as well. Input : [image] Output: [image] …