use the round function
=round(A1,3)
where A1 is the cell containing your number and
3 is the number of decimals you want to show
if A1=1.234567 the result of above function will be 1.235
Note that the number of decimals can be 0 to obtain a whole
number: round(12.5,0) ==> 13
or even negative to obtain multiple of 10, 100, 1000 etc...
round(125,-2) ==> 100
round(6543,-3) ==> 7000
-----Original Message-----
I'd like to round a number for example 1,234,567 to 1,235
million. How do I do that as a function in Excel?
