[<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

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

In article ,
"Epinn" wrote:

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

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

*good* link

Epinn

"JE McGimpsey" wrote in message ...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

http://office.microsoft.com/en-us/ex...986791033.aspx

Is a nice one, well, I think so.

Epinn wrote:

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

*good* link

Epinn

"JE McGimpsey" wrote in message ...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

--

Dave Peterson

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

"Dave Peterson" wrote in message ...
http://office.microsoft.com/en-us/ex...986791033.aspx

Is a nice one, well, I think so.

Epinn wrote:

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

*good* link

Epinn

"JE McGimpsey" wrote in message ...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

--

Dave Peterson

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

Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text values. Each of these Sections are separated by a semi colon (;). If you create a custom number format you do not have to specify all four sections. By this I mean, if you included only two sections, the first section would be used for both positive numbers and zero values, while the second section would be used for negative numbers. If you only used one section, all number types would use that one format. Text is only affected by custom formats when we use all four sections, the text would use the last section. <<

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

"Dave Peterson" wrote in message ...
http://office.microsoft.com/en-us/ex...986791033.aspx

Is a nice one, well, I think so.

Epinn wrote:

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

*good* link

Epinn

"JE McGimpsey" wrote in message ...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

--

Dave Peterson

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


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

Excel see a cells format as having four Sections. These are, from
left to right Positive numbers, Negative Numbers, Zero Values and
Text values. Each of these Sections are separated by a semi colon
(;). If you create a custom number format you do not have to specify
all four sections. By this I mean, if you included only two sections,
the first section would be used for both positive numbers and zero
values, while the second section would be used for negative numbers.
If you only used one section, all number types would use that one
format. Text is only affected by custom formats when we use all four
sections, the text would use the last section. <<

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

"Dave Peterson" wrote in message
...
http://office.microsoft.com/en-us/ex...986791033.aspx

Is a nice one, well, I think so.

Epinn wrote:

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

*good* link

Epinn

"JE McGimpsey" wrote in message
...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

--

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.

Epinn wrote:

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

Excel see a cells format as having four Sections. These are, from left to right Positive numbers, Negative Numbers, Zero Values and Text values. Each of these Sections are separated by a semi colon (;). If you create a custom number format you do not have to specify all four sections. By this I mean, if you included only two sections, the first section would be used for both positive numbers and zero values, while the second section would be used for negative numbers. If you only used one section, all number types would use that one format. Text is only affected by custom formats when we use all four sections, the text would use the last section. <<

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

"Dave Peterson" wrote in message ...
http://office.microsoft.com/en-us/ex...986791033.aspx

Is a nice one, well, I think so.

Epinn wrote:

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

*good* link

Epinn

"JE McGimpsey" wrote in message ...
How about Help ("About custom number formats")?

In article ,
"Epinn" wrote:

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

--

Dave Peterson

--

Dave Peterson