Use this formula to convert to TEXT, then copy PasteSpecial Values to get rid
of the formulas.........(use however many zeros you need).....

=TEXT(A1,"0000000")

Vaya con Dios,
Chuck, CABGx3





"Laury" wrote:

I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
to get these numbers into text format, but keep the lead zeros and I can't
figure out how.

When I double click on the cell, the zeros disappear. If I copy and paste
to a text formatted cell, the zeros disappear. Any suggestions?