CALC convert text to numbers

users
#1

Oh, here's another way:
o Ensure that the cells with your rogue values are actually formatted as numbers. (No, that won't solve your problem, but bear with me.)
o Select the cells.
o Search for .* and replace with & - but click More Options and tick "Current selection only" and "Regular expressions". The text values are reinserted in their cells, but are also reinterpreted - as numbers.

I trust this (also) helps.

Brian Barker