custom format

[Epinn]

Re: [<1000]0-00;00-000 for 1-22 and 12-434

I picked up the above solution from another thread. Then I created my own test.

I tested with

0-00;00-000 and
00-000;0-00 respectively.

No [<1000] for both.

Without the condition [<1000], it will always pick up the *first* format regardless of how many digits we key or how many formats we have. That's just the way it is, right? For number formats, it will pick up the right format depending on whether the number is positive or negative. We have to enter the formats in a specific order for positive, negative etc.

Is there a good link that I can use to learn more about custom format?

Thanks.

Epinn

 

[JE McGimpsey]

How about Help ("About custom number formats")?

 

[Epinn]

I have read that and one other link before. Still not satisfied.

*good* link

Epinn

How about Help ("About custom number formats")?

 

[Dave Peterson]

http://office.microsoft.com/en-us/excel/HP051986791033.aspx

Is a nice one, well, I think so.

 

[Epinn]

That link is the same as Help text and I have read it. Yes, it is okay. Thanks, anyway.

I was hoping that you could answer my other queries regarding [<1000]0-00;00-000. That was my reason for inviting you to this thread.

Appreciate comments.

Epinn

http://office.microsoft.com/en-us/excel/HP051986791033.aspx

Is a nice one, well, I think so.

 

[Epinn]

I read the following but still don't quite understand [<1000]0-00;00-000. Please explain.

Regarding [<1000]0-00;00-000, if I understand correctly, the user will key in the numbers (positive) without the dash. Custom format puts in the dash, right? According to the above, two sections = one positive and one negative format. But that's not the case for 0-00;00-000.

I am missing something.

Please help.

Epinn

http://office.microsoft.com/en-us/excel/HP051986791033.aspx

Is a nice one, well, I think so.

 

[Roger Govier]

Hi Epinn

I know it talks about positive, negative etc., but help also talks
about cell values matching different conditions.
I think you need to interpret it as IF - THEN - ELSE

Try using [<10000]0-00;[-100000]00-000;000-000
and then enter
1 0-01
12 0-12
123 1-23
1234 12-34
12345 12-345
123456 123-456



--
Regards

Roger Govier


I read the following but still don't quite understand
[<1000]0-00;00-000. Please explain.

Regarding [<1000]0-00;00-000, if I understand correctly, the user will
key in the numbers (positive) without the dash. Custom format puts in
the dash, right? According to the above, two sections = one positive
and one negative format. But that's not the case for 0-00;00-000.

I am missing something.

Please help.

Epinn

http://office.microsoft.com/en-us/excel/HP051986791033.aspx

Is a nice one, well, I think so.

 

[Dave Peterson]

Read the help once more, but look at the Color and Conditions section. It
describes how to use colors, but the same technique can be used for the number
format.

I read the following but still don't quite understand [<1000]0-00;00-000. Please explain.

Regarding [<1000]0-00;00-000, if I understand correctly, the user will key in the numbers (positive) without the dash. Custom format puts in the dash, right? According to the above, two sections = one positive and one negative format. But that's not the case for 0-00;00-000.

I am missing something.

Please help.

Epinn

http://office.microsoft.com/en-us/excel/HP051986791033.aspx

Is a nice one, well, I think so.

I have read that and one other link before. Still not satisfied.

*good* link

Epinn

How about Help ("About custom number formats")?