I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

How about: 00"-"0"-"00000"-"0
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"N.F. Jackson" <N.F. wrote in message
...
I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

Use a custom format of:
00-0-00000-0



N.F. Jackson wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson

0#-#-#####-#

00-0-00000-0

Either one works for me


Gord Dibben MS Excel MVP

On Sat, 19 Jul 2008 08:25:00 -0700, N.F. Jackson <N.F.
wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

I'd try them again. I think you made a mistake.

N.F. Jackson wrote:

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson

I tried it again. Still no cigar: Format 00-0-00000-0

Input

97012345 gets 00-9-77012-3 and 007123456 = 00-0-07123-5



"Dave Peterson" wrote:

I'd try them again. I think you made a mistake.

N.F. Jackson wrote:

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson

It works fine for me.

I think something else is sticking its head in (maybe an event macro???)

If you start a new workbook and format A1 nicely, the type that value, do you
still have the same trouble?

N.F. Jackson wrote:

I tried it again. Still no cigar: Format 00-0-00000-0

Input

97012345 gets 00-9-77012-3 and 007123456 = 00-0-07123-5

"Dave Peterson" wrote:

I'd try them again. I think you made a mistake.

N.F. Jackson wrote:

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson


--

Dave Peterson

Thanks, Dave. In a new workbook it still inserts two zeros in the leading
two positions and truncates the end when I type in 977123456 and 007123456

"Dave Peterson" wrote:

It works fine for me.

I think something else is sticking its head in (maybe an event macro???)

If you start a new workbook and format A1 nicely, the type that value, do you
still have the same trouble?

N.F. Jackson wrote:

I tried it again. Still no cigar: Format 00-0-00000-0

Input

97012345 gets 00-9-77012-3 and 007123456 = 00-0-07123-5

"Dave Peterson" wrote:

I'd try them again. I think you made a mistake.

N.F. Jackson wrote:

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson


--

Dave Peterson

OK, think I have it... I turned off the fixed decimal = 2 in the
Tools/Options, then the custom number format worked for new case numbers
input into pre-formatted cells.

"Dave Peterson" wrote:

It works fine for me.

I think something else is sticking its head in (maybe an event macro???)

If you start a new workbook and format A1 nicely, the type that value, do you
still have the same trouble?

N.F. Jackson wrote:

I tried it again. Still no cigar: Format 00-0-00000-0

Input

97012345 gets 00-9-77012-3 and 007123456 = 00-0-07123-5

"Dave Peterson" wrote:

I'd try them again. I think you made a mistake.

N.F. Jackson wrote:

Thanks, Fellas... but none of them work all the time.

Using all the suggested formats I could not get the following input to yield
the desired format in parentheses following:

007123456 = (00-7-12345-6)
977123456 = (97-7-12345-6)

I think I actually had this down at one time, but can't reconstruct it, nor
find the workbook where I may have successfully created the format.

"N.F. Jackson" wrote:

I need to format cells for a case number of 9 digits, with hyphens as
indicated:

##-#-#####-# (we need to key in 9 digits and have the hyphens inserted)

Where the first two may ormay not be zeros and where the third set of five
may have leading zeros.

E.g. 97-3-00123-4 or 00-8-12345-6 or 08-1-00001-6

--

Dave Peterson


--

Dave Peterson