Number Format not working
Hello this is my custom number format [<1]0.00%;$#,##0.00
If I enter the number 5 I get 5.00% if I enter 100.00 I do not Get $100.00
I get $1.00 This is what i'm trying to do. anything from1 to 5 should
be in % above 5 should be in $ thanks thanks thanks
|