Sum function in excel not working

Help Studio
, ,
1

Hi, I have standart exel and its data changes mountly(I collumn). Its data came from another excel with “Write Range Workbook”. But when I paste this data function in “I4” not working. I have to cahnge column type and click double on number. How can I do this automatically?

Capture
Capture176×709 12.4 KB

Capture2
Capture2171×703 11.1 KB

2

@murat.karasoy

After pasting the data please try using format cell or range activity and provide the format as double

https://docs.uipath.com/activities/docs/format-range-x

Cheers

3

image
image772×536 27.6 KB

thanks I changed formats but still I have to double click to number.

4

@murat.karasoy

That might be because of the format of your number i see comma as the decimal separator and excel is not interpreting it properly…

Try making the column as double in your datatable

Cheers