Use a formula like

=ROUNDUP(A1,-3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"Ed Vega" <Ed wrote in message
...
In excell the formula to take the resulted value and round in
up to the
nearest thousand