Date time format fixed

[Gokul001 (Gokul Balaji)]

Hi @Waka

Use format cell activity to change the format as per your requirement

Check out this tutorial

[Part 1] Modern Activities - Find/Replace Value | Format Cells

Hello Everyone, Hope you are doing good I would like to present this post who are looking for the Modern Activities Very first thing is to Enable the Modern experience (from Classic) Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Let Jump into the Tutorial we are look into some Modern activities Find/Replace Value Format Cells Note : We need to use Excel Process Scope and Use Excel File for all the above activities Excel Process scope Use Excel File …

Check out this thread

Strong parsing of a string to Date in MM/dd/yyyy format

HI @Aakash_Singh_Rawat You can try with strong Date Parsing DateTime.ParseExact("Jan 01, 2022",{"MMM dd, yyyy","MMM d, yyyy","dd/MM/yyyy","MM/dd/yyyy"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString("MM/dd/yyyy") Output [image] Regards Gokul

How to change cell format as text using UiPath or excel formula

Hi @Baby123 Go to → Activities Panel → Click on Filter → Select Show Modern. [image] Step 1 : Use Excel process scope followed by Use Excel file activities. Step 2 : Use Format Cell Activity, Check out the XAML file FormatCellStudioX.xaml (8.5 KB) Regards Gokul

Regards
Gokul