Sum column, but the cell format is in text

Help Activities
, ,
1

Dear all,

I want to sum a column from an excel file pasted by the robot in previous activity. I use a write cell activity “=SUM(L:L)” but it is not working due to the cell format in excel (see atached):

image

The green corner of the cell causes that the sum is 0. If I click manually on the green corner, excel gives me the possibility to convert to number, and it works. But if I convert automatically with the robot the cells to Number, it does not work.

How can I solve this issue?

Many thanks! :slight_smile:

2

Try:

  1. Set the column format into general/number manually.
  2. Run the robot, executing the write cell with formula.
3

I will try, but i do need it automatically, not manually…

4

I have realized that it is already in general format. I didnt modify it.

image

5

Did you find the solution to make the BOT write directly the number format?