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?

[Manju_Reddy_Kanughula]

Input excel

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

[Yoichi]

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?

Regards,

[Gokul001 (Gokul Balaji)]

Hi @Manju_Reddy_Kanughula

You can convert text to number using Change cell format activity

Check out the link

BalaReva

Regards
Gokul