Format number cells to the nearest 1,000

[Macgregorblack]

Format number cells in an Excel spreadsheet to the nearest 1,000.

For example 459,650 to appear as 460,000

 

[Jim Thomlinson]

Format Cells -> Number -> Custom and add the following format
0,",000"

 

[David Biddulph]

=ROUND(A2,-3)