Format cells in Use Excel File activity

[sullivanne]

Hi, I wanted to change the date format in a column in Excel from dd.MM.yyy to dd-MM-yyyy, I added the “format cells” activity and it converts, but does not enter the year. It looks like this: 17/07-yyyy. Do you have any idea?

[mkankatala (Mahesh Kankatala)]

Hi @sullivanne

In the source field in the Format cells activity give the range,

Excel.Sheet("Sheet name").range("A2:A10")

Hope it helps!!

[rlgandu (Rajyalakshmi Gandu)]

@sullivanne
For each row in excel

CurrentRow("Date")=DateTime.ParseExact(CurrentRow("Date").ToString(), "dd.MM.yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd-MM-yyyy")

[ashokkarale]

@sullivanne,

Try putting the custom date expression once again. Somehow Studio is not able to understand the year part.

Also try updating UiPath.Excel.Activities to latest possible version.

Thanks,
Ashok