Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting 99.997% to 99.99%
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting 99.997% to 99.99%
There is no format which will do this. You will need a formula, like:
=rounddown(a1,4) Regards, Fred "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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting 99.997% to 99.99%
that is happening because by default the decimal is being rounded UP and not
DOWN try this =ROUNDDOWN(B2,4) -kc *clikc YES if this helps "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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |