Thread
:
Lead Zeros to Show?
View Single Post
#
5
Myrna Larson
Posts: n/a
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.
.
Reply With Quote