=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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
