Need To Change Entire Column Type

[Rishik_Chowdary]

Hi,

I want to change entire column type of general to date.

Attached Screenshot below.

Thanks,
Rishi

[raja.arslankhan]

@Rishik_Chowdary
Please check this one:

Change Format in Excel (General to Date)

No, the week number is in AD3. i want to write the date into AD2

[Nitya1 (Nitya Tomar)]

Hi @Rishik_Chowdary

Try this-

row(“ColumnName”) = DateTime.Parse(row(“ColumnName”).ToString())

Thanks!!

[Anil_G (Anil Gorthi)]

@Rishik_Chowdary

Please use format cells activity and give the required column as range and select the date as the type

https://docs.uipath.com/activities/docs/format-range-x

Cheers