Formatting 99.997% to 99.99%
=ROUNDDOWN(A1,4)
and format as % with 2 decimals
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"lawandgrace" wrote in message
...
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!
|