you could use NUMBERVALUE to translate numbers from a locale-specific text format into a locale-independent number.
To perform a numeric conversion, the NUMBERVALUE function uses the custom separators you provide.
Thedecimal_separatoris the character used to separate integers from fractional values in the source text.
Thegroup_separatoris the character used to group text by thousands in the source text.
Both separators should be enclosed in double quotes ("").
Whendecimal_separatorandgroup_separator, Excel uses separators for the current locale.
a number, date, or time format) into a numeric value.
Normally, the VALUE function is not needed in Excel, because Excel automatically converts text to numeric values.
DATEVALUE Function
The Excel DATEVALUE function converts a date represented as atext stringinto avalid Excel date.
Numeric time values are more useful than text since they can be directly…
