formatting

  • Thread starter Thread starter jopla
  • Start date Start date
J

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.
 
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.
Click to expand...
 
Back
Top