PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
How do I eliminate repeating decimals
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Crashes
How do I eliminate repeating decimals
![]() |
How do I eliminate repeating decimals |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
I have down loaded data from SAP. Subtracted data A from Data B. Result
shows exponetial decimal place. Tried to round, Truncate, and all other thing that come to mind but can not get rid of the extended decimal places. |
|
|
|
#2 |
|
Guest
Posts: n/a
|
You need to change the number format:
1. Select the cell(s) you want to modify 2. Click on the "Format" menu, and then on the "Cells" option 3. Click on the "Number" tab 4. Select "Number" from the list below 5. Adjust your options (such as decimal places) 6. Click on OK 7. Hope this helps, and if it does, I always appreciate it if you reply Greetings from Mexico! "Fred R" wrote: > I have down loaded data from SAP. Subtracted data A from Data B. Result > shows exponetial decimal place. Tried to round, Truncate, and all other > thing that come to mind but can not get rid of the extended decimal places. |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

