| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding
I am trying to round into the millions. For example, I want to format
5,450,000 to 5.5 Everything I have tried so far is to the thousandth which gave me 5,450. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
try
=roundup(5450000,-5)/1000000) that should do the trick wrote: I am trying to round into the millions. For example, I want to format 5,450,000 to 5.5 Everything I have tried so far is to the thousandth which gave me 5,450. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
Try this:
=CEILING(A1,10^5)/10^6 " wrote: I am trying to round into the millions. For example, I want to format 5,450,000 to 5.5 Everything I have tried so far is to the thousandth which gave me 5,450. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Rounding
If you just want to do this via cell formatting, without changing the
underlying value, try this custom format 0.0,, " wrote: I am trying to round into the millions. For example, I want to format 5,450,000 to 5.5 Everything I have tried so far is to the thousandth which gave me 5,450. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
| Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
| Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
| Rounding or not rounding | Excel Worksheet Functions | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Hybrid Mode
