zhutao said:
how to transform string ( include only numbers ) to number
=value("1234") => 1,234 (Note the pair of double quotes. The string must
only contain numbers with at most one "." and optionally a leading "-" or
"+".)
=value(B1) will return a numerical value for a text string in B1 if the
string begins with a single quote ('1234). Same constraints on the string
apply as above.
