Menu
All articles with 'numbervalue()' Tag
{ 11 Comments }
Use NUMBERVALUE() to convert European Number format
Published on Oct 6, 2015 in Excel Howtos, Learn Excel
If you deal with customers or colleagues in Europe, often you may see numbers like this:
- 1.433.502,50
- 9.324,00
- 3,141593
When these numbers are pasted in Excel, they become text, because Excel can’t understand them.
Here is a simple way to convert the European numbers to regular ones.
Use NUMBERVALUE() Function.
Continue »
