How to show leading zeroes

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I seem to have tried all the formats under
Format/Cells/Numbers and it keeps dropping my leading zeroes.

For example, I'll type 000972, and it shows as 972.

Any ideas anybody?

Thanks, Al at the Truck Center, North Haven, CT
 
Al at the Truck Center:

(btw - your name's AWESOME!) just type a single quote '
before the number:

'000972

Hope that helps,
Karen
 
The only way I know to show the leading zeroes is to
formate the cell as text. If that doesn't work actually
type the ' - before the 000's and it should show
everything.
 
I seem to have tried all the formats under
Format/Cells/Numbers and it keeps dropping my leading zeroes.

For example, I'll type 000972, and it shows as 972.

Any ideas anybody?

Thanks, Al at the Truck Center, North Haven, CT
Click to expand...

Format/Cells/Custom/Type: 000000


--ron
 
the other solutions will work, but if you still need the
result to be a number, not text, format it this way:

format.. custom

type " 000000" in the custom format box

the leading space is critial

put zeros in to match the length of you number [6 in my
example]

works like a champ
 
Back
Top