My Percentages show to many Zeros. Why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a SQL Linked table for which I can not change any datatypes etc. It is
set to a Number DataType. When I select Percentages and 1 decimal. It does
not show the correct results. Example: I want it to look like this -49.9%.
The results show
-4999.0%. Can someone help me with this. I feel I tried everything? Thanks
again
 
Percent is a fraction. If you have computed it as 49.6% it is stored as a
number, not as a percent. And then when you tell it to format it as a
percent it multiples by 100 and includes the percent sign.
 
You must log in or register to reply here.

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

Similar Threads

FormatPercent Function - Access 2003 2
Show percentage sign in results? 3
Excel How to calculate percentage for time 1
Percentage Change 2
Field Name - Data Type - Percentage 10
Calculate percentage 2
Too many decimal places in Pie Chart 1
variable for percentage 4

Back
Top