Lead Zeros to Show?
 

What is the formula for the function MID to get lead 0s to show like on a
social security number.

for example: I see right now 56769584 but I want to see in the cell
056769584.

=TEXT(A1,"000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the formula for the function MID to get lead 0s
to show like on a
social security number.

for example: I see right now 56769584 but I want to see
in the cell
056769584.
.

Thanks but that did not work. I know that it is a MID function and I used to
be able to do it but I can't remember. Laurie

"Jason Morin" wrote:

=TEXT(A1,"000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the formula for the function MID to get lead 0s
to show like on a
social security number.

for example: I see right now 56769584 but I want to see
in the cell
056769584.
.

Jason,

I got it to work. Thanks I'm an idiot! Regards, Laurie

"Jason Morin" wrote:

=TEXT(A1,"000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the formula for the function MID to get lead 0s
to show like on a
social security number.

for example: I see right now 56769584 but I want to see
in the cell
056769584.
.

YOu can also simply use a custom format like "000000000".

On Wed, 9 Feb 2005 09:33:03 -0800,
wrote:

Jason,

I got it to work. Thanks I'm an idiot! Regards, Laurie

"Jason Morin" wrote:

=TEXT(A1,"000000000")

HTH
Jason
Atlanta, GA

-----Original Message-----
What is the formula for the function MID to get lead 0s
to show like on a
social security number.

for example: I see right now 56769584 but I want to see
in the cell
056769584.
.