How to show leading zeroes

[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

 

[greg mansius [MSFT]]

What happens if you format the cell as Text?

 

[Karen]

Al at the Truck Center:

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

'000972

Hope that helps,
Karen

 

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

 

[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

Format/Cells/Custom/Type: 000000


--ron

 

[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

 

[lydia]

make it a custom number, with all the 000's you need.
don't mnake it text!

-----Original Message-----