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