How to round to millions

[ADITYA]

Hi All,
What is the Formula / command to round off million to the number to nearest millions in MS Excel.

for example Rs 1,90,87,169 to 19.1 millions

Regards
Aditya

 

[NARAYANK991]

Hi Aditya ,

One possibility is to leave the value as it is , and change the cell formatting to display it in millions :

#,,.##

will display 19.09 ;

#,,.#

will display 19.1

If you really want the value itself to be changed to 19.1 , then use the formula :

=ROUND(number/10^6,1)

where number is 19087169 without the commas , since with those extra commas , Excel takes it as text.

Narayan

 

[Debraj]

use Custom Format as 0,,.0 \m
or
=TEXT(A1,"0,,.0 \m")