how to customize data type for percentage

B

brodriguez

I selected the data type as number and the format as percentage... but when I
write 20% it comes out 2000%. How o I make that to show only 2 places
instead of 4?

Thank you
 
J

John Spencer

Type .2 for 20 percent.

Or store the nominal value of 20 and manipulate by dividing by 100 when
you need the percent value for calculations.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top