Convert excel cell format to general

Im confronting with problem that date data is expressed as ###### in excel cell
Threfore, i would like to change the cell format to general. However, im in a situation that i cannot utilize
send hotkey activity.

How should i change cell format to general from other formats??

A way you can solve this is to write a macro that will add an apostrophe (’) before each date. This will force it to be of the text type, and when you read the cell, it will disregard the apostrophe, and it will not show up in the cell.

Hi @Jacob_Mintzer!
So, after converting the cell to text type by adding an apostrophe, will UiPath be available to compare the dates?

Hi,
Here is the activity is called “ChangeCellType”. You can able to specify the custom format whatever you like. Take a look in the blow link with example.

Regards
Balamurugan.S