What activities can I use to edit a column on an excel sheet? I am trying to change a entrie column from displaying date and time to just displaying the date .

ExcelHelp

balupad14 (Balamurugan) July 23, 2020, 9:22pm 14

here is an activity called change cell type and you can specify the range as like “C:C” .

Video :

Regards
Balamurugan.S

1 Like

Topic		Replies	Views
Change Column Type to Date through Assign Help datatable , activities , question	6	2962	December 22, 2019
How to change the data format in a excel files Help datatable , excel , activities , question	6	987	December 19, 2019
While reading an excel sheet, the format of date in column changes Help studio	6	1304	February 24, 2020
Assign Date Column Activities uiautomation , studio , question	4	597	March 1, 2021
Date format: Read range as dd/MM/yyyy and write range as MM/dd/yyyy Help datatable , activities , question , data_manipulation	7	8875	November 19, 2019