Converts text to a number in a locale-independent way.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
NUMBERVALUE(text, [decimal_separator], [group_separator])The NUMBERVALUE function converts text to a number by allowing you to specify custom decimal and group separators. This is particularly useful when importing data from different regions where number formatting conventions vary.
=NUMBERVALUE("1.234,56", ",", ".")결과: 1234.56
Converts a European-formatted number string using a comma as a decimal separator into a standard numeric value.
NUMBERVALUE is locale-independent and allows you to define custom separators, whereas VALUE relies on the system's regional settings.