Hi
one way: use a helper column with a formula such as
=TEXT(A1,"00000")

--
Regards
Frank Kabel
Frankfurt, Germany

"Altaf Choudry" <Altaf schrieb im
Newsbeitrag ...
I can put leading zero by changeing the cell format, but when I rum
mail
merge through and attach an Excel file, my leading zero are missing.
For
example, Newark, NJ 07102 (it will display and print 7102). It
happens in all
MS Office versions released after Office 2000.