All articles with 'fixed' Tag
Use NUMBERVALUE() to convert European Number format
If you deal with customers or colleagues in Europe, often you may see numbers like this:
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 »
18.2 Tips on Rounding numbers using Excel Formulas
Lets talk round numbers today.I have 18.2 tips for you on round numbers.
We can use a variety of formulas to round numbers in Excel depending on the situation. We have ROUND, ROUNDUP, ROUNDDOWN, MROUND, INT, TRUNC, CEILING, FLOOR, FIXED, EVEN, ODD and few more. To know how to use all these formulas and how to round numbers based on any criteria, just read on.Continue »