Use NUMBERVALUE() to convert European Number format
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.
Excel is 30!!! – what was your earliest memory of Excel? [weekend poll]
This week Excel turned 30. As per wikipedia,
Microsoft released the first version of Excel for the Macintosh on September 30, 1985
Let’s celebrate 30 years of Excel by reliving your first memory of it. Share your earliest memory of Excel in the comments section.
Weighted Sorting in Excel [video]
Imagine you are looking customer data like below and want to sort them by performance. If you sort the data by any one column, you will not get full picture of performance. To understand which customers rank low on performance, you need to defined a weighed sort, the kind of sort where you assign weights to each attribute (customer age, recent purchases and rate of returns) and come up with single score to sort them all.
Sounds interesting? Watch below video to understand how to do weighted sorting in Excel.