| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
eliminating decimal places
On an excel spreadsheet downloaded from an external source there are eight
decimal places in the numbers. If I format to two decimals it displays the number with two decimals but still keeps the eight decimals when in the cell. This makes it difficult to upload the info into our ERP system as that system rounds differently. How can I permanently get rid of the extra decimals? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Decimal Places | Excel Discussion (Misc queries) | |||
| Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
| Max decimal places | Excel Discussion (Misc queries) | |||
| FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
| add 2 decimal places | Excel Discussion (Misc queries) | |||
![Catherine[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
