Number Format not working

Wanna Learn · External Since: Aug 29, 2006 Posts: 124

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

David Biddulph · External Since: Feb 24, 2007 Posts: 1097

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" <WannaLearn RemoveThis @discussions.microsoft.com> wrote in message
news:048FBD7F-3931-43BF-8485-0A539915B334@microsoft.com...
> 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

Wanna Learn · External Since: Aug 29, 2006 Posts: 124

Thanks David
I tried and checked everything you suggested and still does not work

"David Biddulph" wrote:

> 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" <WannaLearn RemoveThis @discussions.microsoft.com> wrote in message
> news:048FBD7F-3931-43BF-8485-0A539915B334@microsoft.com...
> > 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
>
>
>

David Biddulph · External Since: Feb 24, 2007 Posts: 1097

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" <WannaLearn.RemoveThis@discussions.microsoft.com> wrote in message
news:C6206CA5-342E-4795-8C3D-B9EF3E621E55@microsoft.com...
> Thanks David
> I tried and checked everything you suggested and still does not work
>
> "David Biddulph" wrote:
>
>> 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" <WannaLearn.RemoveThis@discussions.microsoft.com> wrote in message
>> news:048FBD7F-3931-43BF-8485-0A539915B334@microsoft.com...
>> > 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
>>
>>
>>