Thread: Format number cells to the nearest 1,000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default 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


Reply With QuoteReply With Quote