Thread: Format number cells to the nearest 1,000
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default 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
Reply With QuoteReply With Quote