How to change date format in excel file?

[SURESH_P]

Hi All,

How to change date format in excel like “12/08/2022” to change as “02-12-2022” in all rows.

Thanks in Advance…!

[Gokul001 (Gokul Balaji)]

HI @SURESH_P

How about this expression?

DateTime.ParseExact("12/08/2022","MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Regards
Gokul

[Anil_G (Anil Gorthi)]

Hi @SURESH_P

Please try this activity

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

cheers

[Gokul001 (Gokul Balaji)]

Hi @SURESH_P

You can try with Format cell activity or change cell type activity

Format Cell

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

https://docs.uipath.com/studiox/docs/tutorial-formatting-cells

Change cell Type

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @SURESH_P

Go to → Activities Panel → Click on Filter → Select Show Modern.

Step 1 : Use Excel process scope followed by Use Excel file activities.

Step 2 : Use Format Cell Activity,

You can try to change the format of the column

1. Excel process scope activity
2. Use excel file activity
3. Format cell activity

Regards
Gokul

[Rahul_Unnikrishnan]

Hello @SURESH_P

You can use the below expression or the modify date activity.

DateTime.ParseExact(strVar, "MM/dd/yyyy", Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

Thanks