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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding value in place
I think that you will need to use a helper column. Insert a temporary column
beside the numbers and use the following formula example:- =MROUND(A4,1000000) Copy the formula down for the length of the data. Select and Copy the helper column then Select the original data column and then Paste Special - Values. You can then delete the helper column. -- Regards, OssieMac "Bagia" wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding value in place
Hello,
If I understand the question correctly, a sub is needed. Example: Sub round2mill() Range("A1").Formula = Application.WorksheetFunction.Round(Range ("A1").Value, -6) End Sub Regards, Bernd |
Reply |
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 |