| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ROUNDING FORMULA =ROUND(B12/$B$10,1) ROUNDING TO HIGH | Excel Worksheet Functions | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| Decimal Place Rounding | Excel Worksheet Functions | |||
| Rounding errors when a "5" is the third decimal place using formul | Excel Discussion (Misc queries) | |||
| 1st, 2nd, 3rd Place etc..... | Excel Worksheet Functions | |||
Threaded Mode
