Format number cells to the nearest 1,000
 

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

For example 459,650 to appear as 460,000

Format number cells to the nearest 1,000
 

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

Jim Thomlinson


"Macgregorblack" wrote:

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

For example 459,650 to appear as 460,000

Format number cells to the nearest 1,000
 

=ROUND(A2,-3)
--
David Biddulph

"Macgregorblack" wrote in message
...
Format number cells in an Excel spreadsheet to the nearest 1,000.

For example 459,650 to appear as 460,000