Forum home » Delegate support and help forum » Microsoft Access Training and help » Formatting percentages
|
|
|
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. |
Formatting percentages
Resolved · Low Priority · Version 2002/XP
Reply Mon 28 Apr 2008, 13:27Delegate Steven said...
Steven has attended:
Access Intermediate course
Formatting percentages
When formatting a field to show % how do you stop the figures from automatically rounding up. For example i would like to show 99.71% so i type 0.9971 and it automatically rounds up to 100%. The problem that i face is that all of the records in this field range between 99 and 100% and i need to show them exactly to 2 decimal places.
For upcoming training course dates see: Pricing & availability
RE: formatting percentages
Hi Steven, Thanks for the post, Try this in your table in design view:
Set the Field properties as follows:
Field Size : Decimal
Format : Percent (Or as per your own preference.)
Precision : 18 (Or as per your own preference.)
Scale : 4 (Has to be set in oder to display values after decimal seperator)
Decimal Places : 2 (Or as per your own preference.)
Hope that works, best regards Pete
|