You didn't tell us whether your numbers were divided by 100 compared with
the input values.
You didn't tell us what values you saw when you looked at the cells with a
format of general or number.
You didn't tell us whether or not Fixed decimal places had been set.
You didn't tell us why you'd got [<1] when you were talking about a dividing
line at 5.
Neither I nor any other contributor of this group has a crystal ball. We
can't help you if you don't give us any information to work with.
Just saying "still does not work" doesn't help anyone to help you.
--
David Biddulph
Wanna Learn said:
Thanks David
I tried and checked everything you suggested and still does not work
David Biddulph said:
It looks as if all your input numbers are being divided by 100. You
could
check by temporarily formatting as General or Number.
Try Tools/ Options/ Edit:
Make sure you haven't got Fixed decimal places set.
If your dividing line is supposed to be at 5, why does your custom format
have [<1]?
--
David Biddulph
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