problemi con le funzioni Numbers (sostituire i valori con un punto in virgola)

You can insert a new column with the formula given below to convert the decimal "." to a "," and convert it from text into an actual number.

=SUBSTITUTE(C;".";",")*1

Not sure if I've followed exactly what your are saying but I'm guessing you are obtaining sensor data that is formatted as -23.1 whereas in your region the decimal separator is a comma so you need -23,1 so Numbers can recognize it as a Number.

If so, then you can temporary change your document to a region that uses the period as a decimal separate, then import or paste the sensor data, then switch back to your "home" region. To switch regions just go to File > Advanced > Language and Region ...

You may need to change the language in the second dropdown before you can change the region in the first dropdown.

SG

There is a mistake in your formula. Try this one:

=SOSTITUISCI(C;".";",")*1

Yuri2302 wrote:

(For the record, "search and replace" is now gone😡)

Other members of this forum have reported a problem with search and replace.

I don't have that problem here, but other users report it has been fixed. You should go to System Settings > General > Software Update and make sure you have updated to macOS Sonoma 14.2.1 or later and are running Numbers 13.2

SG

A better solution may be to use SGIII's "Find and Replace in Selection" shortcut (or script). You can select the column and find/replace the dots with commas. Numbers will convert the data from text to Number at the same time. No additional column of formulas will be required.