I want to change a cell's format from generic to date

I am getting from data from an email and is putting it in a data table. One of the specific column is supposed to be a date and when I use write range and put the data into excel, the data that was supposed to be dates are all in generic format. Is there a way I can use an activity to change the format of the cell.

Hi Eric,

Welcome to UiPath Forum.

Please refer this custom activity that is useful for your requirement:

Use the activity Change Cell Type in this above package

For how to write the type please refer to this link : Excel data formatting
some examples can be seen

Also, exceltactics.com/definitive-guide-custom-number-formats-excel/

Please mark as solution if your query is answered

Thanks,
Arun

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.