How change text setting to number with command or activity in Excel?

Help Activities
, , ,
4

Hi @Nightowl_music

You can try these ways.

  1. read the excel using excel activity [ excel application scope] & write it to same excel using write range. This may convert the text format to number

---------------------------------- OR----------------------------

  1. Another way would be to use VBA, use invoke VBA activity to run vba script to convert the type of cells from text to number.

Thanks & Regards,
Nived N