Excel to csv conversion

when ever i am converting excel to csv
the date format changes to
12/01/2021 To 12/01/2021 00:00:00

why this 00:00:00 is coming .

please let me how to remove it.

Hi @hamid_hussain

The reason why it is coming is the cell format type provided

Can u share the screenshot of how u done the excel to csv conversion

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed:

1 Like

@hamid_hussain When you use read range activity, check the preserve format check box to true, so that the format of cells will not get changed in the datatable variable.

Uncheck preserve format checkbox while reading range.