Thread
:
Formatting 99.997% to 99.99%
View Single Post
#
3
Posted to microsoft.public.excel.misc
Sean Timmons
external usenet poster
Posts: 1,696
Formatting 99.997% to 99.99%
=ROUNDDOWN(A2,4) should do it
"lawandgrace" wrote:
If I modify it, it always goes to 100% instead of 99.99%, and I need to show
the actual number of 99.99% (without the 3rd decimal place), not the 100%.
Thanks!
Reply With Quote
Sean Timmons
View Public Profile
Find all posts by Sean Timmons