If you know the target cell(s) can be converted to a number (i.e. it is not a
mix of text and number), you can simply use the value function: VALUE(C2) if
C2 contains your number in text format.

"unknown" wrote: