Date Copied is dd/MM/yyyy but when pasted becomes MM/dd/yyyy

[ayeo22]

Need advice

Example:
I copied this date: 12/04/2022 (dd/MM/yyyy) and when I paste to an Excel cell, it becomes MM/dd/yyyy

How do I paste exactly what I copied into Excel?

[Gokul_Jayakumar (Gokul Jai)]

@ayeo22
It is occurred due to different formats in Excel sheet

Refer to this Video to change the Date format in Excel

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

[ayeo22]

any other way besides changing the Date format in Excel?

[Gokul001 (Gokul Balaji)]

Hi @ayeo22

Check out the thread

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

[Anil_G (Anil Gorthi)]

Hi @ayeo22

If you want the format of the excel column to be date then you need to change the format in excel…if you are ok with text then append the value with ‘ single quote at the start

Eg: ‘12/12/2022

Or if you want to format from code then use format cell activity

Cheers

[ayeo22]

How can I do this using Parse Exact?

[Gokul001 (Gokul Balaji)]

Hi @ayeo22

How about this expression

DateTime.ParseExact(YourString.ToString,"MM/dd/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

You can update the format as per the requirement

Regards
Gokul