Convert unknown format to number in excel

Hi everyone,

I am getting an error in my excel sheet due to a format mismatch in a column, I wanted to convert this entire column to number format. Can you please help me with a solution on this?

Hi @Sujith_Reddy

Check out the thread

Hope it will helps

Regards
Gokul

1 Like

Hi @Sujith_Reddy

Welcome to UiPath community. Have a look on the below one

Hello @Sujith_Reddy

Welcome to UiPath community.

You can use Format cells activity to achieve the same. Else another approach is to use a Excel Template with the required formats and write your data to that Template in each execution to keep the formatting.

Thanks