| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Rounding Decimals
Since you want .2228 in the cell, you are looking to round to the 4th decimal
place. You'd use =ROUND(.222849565849694,4) or =ROUND(A1,4) You may also want to look at the Help file for info on the TRUNC() , ROUNDUP() and ROUNDDOWN() functions "Jim May" wrote: I've got 2 or 3 thousand figures that display as (sample) 22.3% with actually 22.2849565849694 in the cell. I need to "do what" ? in order to convert them to display 22.28% with actually .2228 in the cell? Tks in advance |
|
#2
|
|||
|
|||
|
Rounding Decimals
=ROUND(A1,4) works perfectly;
Thanks, Jim "Duke Carey" wrote: Since you want .2228 in the cell, you are looking to round to the 4th decimal place. You'd use =ROUND(.222849565849694,4) or =ROUND(A1,4) You may also want to look at the Help file for info on the TRUNC() , ROUNDUP() and ROUNDDOWN() functions "Jim May" wrote: I've got 2 or 3 thousand figures that display as (sample) 22.3% with actually 22.2849565849694 in the cell. I need to "do what" ? in order to convert them to display 22.28% with actually .2228 in the cell? Tks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding results to nearest quarter (in decimals) | Excel Discussion (Misc queries) | |||
| How do I calculate without decimals in excel? | Excel Worksheet Functions | |||
| rounding numbers, with-out decimals. IE:4507 to 4510 | Excel Worksheet Functions | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
| Rounding Decimals | Excel Worksheet Functions | |||
Hybrid Mode
