Date format is changed when writing the data in excel

[israelesd (Israel)]

Dear, I need your help. Through the activity “get attribute” I capture a date in the format “dd-mm-yyyy”, but when writing that date in excel the format is changed to “mm-dd-yyyy”, how can I avoid this situation?

[balupad14 (Balamurugan)]

Hi @israelesd,

After you write the excel you can change the format of the cell using the below activity.

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

Video :

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

Regards
Balamurugan.s

[Pratik_Wavhal]

Hi @balupad14

Will the above activity work in UiPath Community Version for the same issue ??

Happy Automation

Best Regards
Er Pratik Wavhal

[balupad14 (Balamurugan)]

Hi @Pratik_Wavhal . Yes. I will work…

Thank you
Balamurugan.S