嗨,有好的最佳实践解决文本有限公司nversion "1,234" to a number over Value(txt) giving finally NaN because "," will not be recognized by VALUE(txt). Numbers are given in text format by client as "1,234". Or is it easier to re-format the numbers in the uploadfile...by the client? Thanks in advance for a short feedback. When Numbers are given in text format within thousands separator comma, then comma is not recognized. Is there a good way to solve the given forlmula constraints within VALUE function. Thx
... View more