Thread: Format cell to the nearest 100
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
TKS_Mark TKS_Mark is offline
external usenet poster
  
Posts: 68
Default Format cell to the nearest 100
Gandor: Try =ROUND(A1,-2) where A1 is the number you want to round.

"Gandor" wrote:

Is there a format for rounding a cell to the nearest 100 so that 501.35
rounds to 500. I was using #,##0 to just round to the dollar, but I want to
got to the nearest 100.

Any thoughts?
Reply With QuoteReply With Quote