excel number format - varying decimal digits
- by Alexxx
I'm trying to set a special cell number format with theses rules:
display percentage
display at max 3 digits (decimal + integer part)
So I can display 100% or 99.3% or 1.27%
but not 100.9% or 100.27% or 99.27%.
Of course, I can have negative number (-27.3%) and it does not affect my rules.
I've try with the cell formating option without success:
[<1]0.00%;[<10]0.0%;0%
Because it seemed that excel (2010) does not support more than 2 conditions in cell formating (and so I can't expand it to manage negative number...)
It there anyway to do what I want?
Thanks
