Forum home » Delegate support and help forum » Microsoft Access Training and help » access database course - Formatting numbers
|
|
|
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. |
access database course - Formatting numbers
Resolved · Low Priority · Version Standard
Reply Tue 30 Oct 2007, 13:37Delegate Sabine said...
Sabine has attended:
Access Intermediate course
Formatting numbers
I am having trouble formatting numbers. WHen i am in design value in tables, and i choose percentage as the format, it doesn't format properly. For example if i insert 59%, it comes out as 100%. If i insert 0.59 it comes out as 0. Please help. thanks
For upcoming training course dates see: Pricing & availability
RE: formatting numbers
Hi Sabine,
Thanks for your question.
In the Table Design View:
1) set field as Number
2) in field properties, set field size as either SINGLE/DOUBLE
3) in field properties, set format as PERCENT
Hope this helps.
Regards,
Katie
|