Decimal point or a comma?

When you enter decimal numbers, depending on the Region settings, you will use a decimal point or a comma. In most cases, this is done once, and we don’t deal with this topic anymore. However, it may happen in practice that you import data, most often from a CSS file, where different characters are used to separate decimals and groups than those you use by your local settings. In this case, use the NUMBERVALUE function…

The NUMBERVALUE function has a simple syntax:

NUMBERVALUE (<text>,<decimal separator>, <group separator>)

In the table below, you can see some practical examples where, with the help of this function, we convert text to an adequate numeric value. When converting, the General number format is used. Eventually, by formatting value as as a decimal number, the restult could look even better…