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…!

Hi @SURESH_P Please try this activity https://docs.uipath.com/activities/docs/format-range-x cheers

How to change date format in excel file?

Gokul001 (Gokul Balaji) December 9, 2022, 6:20am 2

How about this expression?

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

Regards
Gokul

Modify date in Excel

Topic		Replies	Views
Modify date in Excel StudioX studiox , question	3	590	September 13, 2023
How to change the excel column (Due Date) format from MM/dd/yyyy to yyyy/MM/dd Studio studio , question , activities_panel	7	386	November 29, 2023
Changing format from "dd/M/yyyy" to "dd/MM/yyyy" in Excel Studio studio , question , activities_panel	9	903	September 26, 2022
How to change DateFormat in UIPath Help excel , studio	7	8228	October 28, 2019
How to change the date format in an excel file Learning Hub datatable , excel , activities , question	5	1012	April 8, 2020