I am taking one column from input excel, the column has to written in output excel like "number stored has a text", so the column have total formula, it is not working due to number stored as text. what is the solution?

Input excel

image

Output excel which is written like “Number stored as a text”
image

Hi,

Which activity do you use? Workbook - Write Range? If so, can you try to use ExcelWriteRange (Write datatable to Excel) with ExcelApplicationScope or UseExcelFile?

image

Regards,

Hi @Manju_Reddy_Kanughula

You can convert text to number using Change cell format activity

Check out the link

Regards
Gokul