Change the excel column format

Help Studio
, ,
1

Hi Devs,

Is there any way to change the excel column format.If I am pressing Enter key in each cell then it is getting changed to proper format.
Can anyone let me know how I can change the format of cell by pressing the enter key in UiPath.

image

If I am pressing enter key in 3rd cell then that date is moving to right side of that cell and format is also getting change. but if I am changing the format to date it is not working as expected.

Thanks,
Riya

2

@Riya1

You can use format cells activity and give the format you need

Cheers

3

You can use the activity “Format Cells” in Excel activities (modern activities), set the range and select the type formato to set in the range.

image