| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding number within cell value
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a number with a formula already in cell | Excel Worksheet Functions | |||
| Rounding number to 0.25 ? | Excel Discussion (Misc queries) | |||
| Significant number rounding based on key cell | Excel Worksheet Functions | |||
| cut off number in excel cell vs. rounding | Excel Discussion (Misc queries) | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Linear Mode
