Forum home » Delegate support and help forum » Microsoft Excel Training and help » Results of Formulas have to many decimal places
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Results of Formulas have to many decimal places
Resolved · Medium Priority · Version 2003
Reply Fri 24 Jul 2009, 16:37Delegate Lee said...
Lee has attended:
Excel Advanced course
Access Introduction course
Access Intermediate course
Results of Formulas have to many decimal places
The results from my formulas often have to many decimal places, if I then import the data to Access or patse into another spreadsheet I have to many characters.
How do I limit the number of decimal places in my results?
For upcoming training course dates see: Pricing & availability
RE: Results of Formulas have to many decimal places
Hello Lee
Thank you for your question.
If you are pasting into another spreadsheet, then maybe using the Paste Special options so that you can choose to paste formats and well as formulas might help, provided you have formatted the formula results to be the number of decimal places you require.
With regard to importing into Access, you might be able to use the Round function in Excel to round your formula results to a specified number of decimal places, then hopefully when the results of the Round function are imported the number of decimal places will remain the same.
Kind regards
Amanda
Mon 3 Aug 2009: Automatically marked as resolved.
|