formatting

[jopla]

I have formatted a cell to have the following format:
#####-####-## (all numbers). This is a NDC number for a
specific drug. In many cases I need leading zeros - in
fact the first 4 numbers may be zeros. Excel ignores the
zeros and returns 78-0377-45, when it should be 00078-0377-
45.

Any ideas? Thanks for the help.

 

[Dave Peterson]

How about a format:

00000-0000-00

I have formatted a cell to have the following format:
#####-####-## (all numbers). This is a NDC number for a
specific drug. In many cases I need leading zeros - in
fact the first 4 numbers may be zeros. Excel ignores the
zeros and returns 78-0377-45, when it should be 00078-0377-
45.

Any ideas? Thanks for the help.