Format a Calculation to % - One Decimal Place

  • Thread starter Thread starter Bob Barnes
  • Start date Start date
B

Bob Barnes

Format(A/B, "Percent")...where A = 1 and B = 3
results in 33.33%.

What can be used to replace the "Percent" to
result in 33.3% ?

TIA - Bob
 
Bob said:
Format(A/B, "Percent")...where A = 1 and B = 3
results in 33.33%.

What can be used to replace the "Percent" to
result in 33.3% ?
Click to expand...

According to Help, Format with Percent *always* returns 2 decimal
places, so I think you need a different approach.

Round(A/B, 3) * 100 & "%"
 
Try the following
Format(A/B,"0.0%")

That should return the desired result

That should work
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top