Ship Date format

[Gokul001 (Gokul Balaji)]

HI @fali1

Before adding the data into the queue You can use Format cell activity to format the Date column in the excel file.

Check out the 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 …

Date and month interchanged while reading from excel

HI @Jayesh_Rathi1 How about this expression? DateTime.ParseExact(CurrentRow("Column Name").ToString.Trim,"MM-dd-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy") Note : dd-MM-yyyy -> Based on excel date fomat Or You can try to change the format of the column Excel process scope activity Use excel file activity Format cell activity [image] Regards Gokul

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

Another Method @Baby123 You can also try with Format cell activity Check out the the Tutorial Range -> Excel.Sheet("Sheet1").Range("A1") [image] Regards Gokul

Regards
Gokul