Forum Discussion
Copied pasted number values from WEB are treated like strings
Hello, I would like to ask about an issue I have while copying and pasting information from the WEB page to excel spreadsheet.
The information I am copying is table, with some strings and some floa...
Just in case, another option could be to keep numbers as it is, but changes formulas. For example, instead of
=SUM(A1:A9)
it could be
=SUMPRODUCT(NUMBERVALUE(A1:A9,"."))
but it very depends on which formulas do you use
- =SUMPRODUCT(NUMBERVALUE(A1:A9;".")) works, but it doesn't change dots and commas, while formulas work, they it is need to be comma as separator on the final paper. I have a feeling i'll have to school them...
