Change Cell Type - Excel



Change Cell Type is not changing all the cells to date format in excel
@balupad14 @Prafull_B

1 Like

Hi @devashish1989

Check this

Excel Date column/General column conversion to dd-mm-yyyy format

Thanks
Ashwin.S

HI @devashish1989,

It will work. Can you do it manually that it will work with the source cell? If it works, definately the change cell type will work. Again if you face the problem. send me a sample xmal with excel file.

Thank you
Balamurugan.S

PFA xaml and excel. Using Ctrl+1 and changing format is not working but using text to column and then selecting date it is changing.Carbon Black Dashboard File.xlsx (119.3 KB) FilterDataTableWithDate.xaml (5.1 KB)

1 Like

HI @devashish1989,

Please check your private message…

Thank you
Balamurugan.S

Thank you @devashish1989 that I had a good discussion with you and your collogue. Have a nice day !!

Balamurugan.S

Thank you so much sir it was pleasure talking to you.

Thanks & Regards,
Devashish

1 Like

As per our discussion, The activity is working well. The source file has the complication.

Thank you
Balamurugan.S