98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Results of Formulas have to many decimal places | Excel forum
Results of Formulas have to many decimal places | Excel forum
Resolved · Medium Priority · Version 2003
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?
Mon 27 Jul 2009, 09:29Trainer Amanda said...
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.
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. |
Excel tip:Repeat actionThe F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again. |
