Thread: Rounding number within cell value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nibbana nibbana is offline
external usenet poster
  
Posts: 8
Default Rounding number within cell value
=ROUND(A2,-5)

"Bagia" wrote:

Hello,

Is there a way to round values within a cell to display the values in
millions? For example, in A2 I have a value of 815,000,001 and would like to
display it as 815,000,000 in the same cell (A2).

Thanks
Reply With QuoteReply With Quote