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

"Wanna Learn" wrote in message
...
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