View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bagia Bagia is offline
external usenet poster
 
Posts: 46
Default Rounding value in place

Is there a way to round a value in place? I have an Excel spreadsheet with
values already entered into their respective cells. Now I would like to
round these values down to the nearest millions, i.e.

A4=815,000,001

I would like A4 now to display 815,000,000

Is there a way?