In this article we will learn how we can round the numbers to thousands with hundreds as a decimal in Microsoft Excel 2010.
To round to thousands with hundreds as a decimal we can use the Custom Format or Round formula.
We can round the numbers 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 the number to Thousands with hundreds 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.
To Round the Numbers to Thousands with Hundreds as a Decimal follow below given steps:-
We will learn about the 2nd way to convert the numbers in thousands with hundreds as decimals.
Round the number by using the Round Function
Let’s understand with a simple exercise
This is the way we can round the number in thousands with hundreds 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.