Using the NUMBERVALUE Function
How to use the NUMBERVALUE function in Excel. The NumberValue Excel function is helpful to convert numbers that are text into numbers that can be used in a calculation. For example when converting certain European currencies to US or UK currencies you need to be able to swap the dots for commas and the commas for dots. Basically, if the decimal separator is a comma then this function is for your. Now I did another solution to this however it was a bit long winded so here goes the succinct solution.
Learn how to better use the NUMBERVALUE Excel function and a whole load more with one of our classroom based Excel Training Courses. This can be conducted and a time and place convenient to your business.