Round Numbers and Dosplay Zeros

[Ken]

Using Excel 2000 and cell A1 containing the number
7,418,212, what is the formula in B1 that will return
7,418,000 in B2? Or with 7,418,545 in A1, it would return
7,419,000.
TIA.

 

[Dale Hymel]

=ROUND(A1,-3)

 

[Biff]

Hi Ken,

Try:

=ROUND(A1,-3)

Biff

 

[Laura]

Divide by 1000, round, and then multiply by 1000 again.