| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you remove excess decimal places in Excel?
I use excel to work out formulations of products that we use. I have found
that although you can change the displayed figure to two decimal places it is still representative of the whole figure. This is an accuracy not required by us and causes problems on further formulating. Is there any function to remove the excess decimal places? I.e. changing 38.8246346 to38.8200000? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I remove excess pages in Excel? | New Users to Excel | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| How do you remove excess spaces from an Excel field? | Excel Discussion (Misc queries) | |||
| Decimal places in Excel 2003 | Excel Worksheet Functions | |||
Threaded Mode
