In this article we will learn about how we can round the numbers to millions with thousands as a decimal in Microsoft Excel.
To round the numbers in Millions with Thousands we can use the Custom Formator Round formula in Microsoft Excel 2010 and 2013.
We can round the numbers to Millions with thousands as a decimal from the 2 different ways.
1st Custom Format
2nd Round Function
Custom Format: -We can use Custom Number Format, to display a Number in Million or Display it in some Color.It’s a tool from in old versions of excel when there was no Conditional Formatting option in Excel. All conditional options are performed by using Custom Number Formal.
ROUND: - This function is used to round a number to a specified number of digits.
Syntax of “ROUND” function: =ROUND (number, num_digits)
Example:Cell A1 contains the number 456.25
=ROUND (A1, 0), function will return 456
Round Numbers to Millions with Thousands as a Decimal by using the Custom Format
Let’s take an example and understand.
We have categorized Income data. In which column D contains City Name, column E contains Gender and column F contains Income in $. We want to format income in Millions.
To Round the Numbers to Millions with Thousands as a Decimal follow below given steps:-
Round the number by using the Round Function
Let’s understand with a simple exercise
This is the way we can round the numberto Million with Thousands as a decimal by using the formula and Custom Format in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.