Or:

=ROUND(A1,-3)

Biff

"Biff" <biffinpitt@comcast.net> wrote in message
news:OF11E7vpGHA.756@TK2MSFTNGP05.phx.gbl...
> Hi!
>
> Try this:
>
> =ROUND(A1/1000,0)*1000
>
> Biff
>
> "AA Arens" <bartvandongen@gmail.com> wrote in message
> news:1152850880.524553.173510@75g2000cwc.googlegroups.com...
>> How to round values to the nearest 1000?
>>
>> Like: 12,549,235 > 12,549,000
>> Like: 12,549,735 > 12,550,000
>>
>> According to Help I should use =ROUND(P9,3-LEN(INT(P9))) but the result
>> is not what I want.
>>
>> Bart
>> Excell 2003
>>
>
>