How to show leading zeroes

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
 
K

Karen

Al at the Truck Center:

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

'000972

Hope that helps,
Karen
 
D

Dianna

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.
 
R

Ron Rosenfeld

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
 
R

rob

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
 
Top