Calculate spreadsheet values

[Alef]

Hello, I want to be able to calculate the values of my spreadsheet.
The column where the values are located is formatted as a number. However, the kodular does not consider them as numbers. Then, it is impossible to calculate.
If I leave it as automatic in the spreadsheet, the value will be considered a number again. Still, it cannot be calculated.

Why does it happen?

Summary

edit: when I select the value, it ends up with a number that does not exist in my spreadsheet.

[dora_paz (Dora)]

Try something like this

[TimAi2 (metricrat)]

or set the locale of your spreadsheet to en which will use a . as the decimal point (there are other locales that do this)

[Alef]

Sorry for the delay to reply.
Well, both methods allow me to get the values using “.” formatting.
However, see what happens …
How can I be getting 2 “Do it”?
In fact, I still can’t calculate it, because they are not considered numbers.

[dora_paz (Dora)]

Global A1 and Global A2 are lists . Use select list - get global A1 -index 1 + select list - get global A2 -index 1 and it will work

See the difference

[Alef]

Oh, sure. Even choosing the first value, it remains as a list.
Dora, thanks for that !!
Have a great day!