software

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?

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,quot;0000000quot;)

Vaya con Dios,
Chuck, CABGx3quot;Lauryquot; wrote:

gt; I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
gt; to get these numbers into text format, but keep the lead zeros and I can't
gt; figure out how.
gt;
gt; When I double click on the cell, the zeros disappear. If I copy and paste
gt; to a text formatted cell, the zeros disappear. Any suggestions?

Didn't work for me. I put in the formula and 00003014150 from the orig cell
changed to 3014150, I then copied and pasted as value and still the cell
showed 3014150. ???quot;CLRquot; wrote:

gt; Use this formula to convert to TEXT, then copy PasteSpecial Values to get rid
gt; of the formulas.........(use however many zeros you need).....
gt;
gt; =TEXT(A1,quot;0000000quot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt;
gt;
gt; quot;Lauryquot; wrote:
gt;
gt; gt; I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
gt; gt; to get these numbers into text format, but keep the lead zeros and I can't
gt; gt; figure out how.
gt; gt;
gt; gt; When I double click on the cell, the zeros disappear. If I copy and paste
gt; gt; to a text formatted cell, the zeros disappear. Any suggestions?

You have to use the same number of zeros as characters in the original value
(including the leading zeros).....in this case 11.......

=TEXT(A1,quot;00000000000quot;)

Vaya con Dios,
Chuck, CABGx3
quot;Lauryquot; wrote:

gt; Didn't work for me. I put in the formula and 00003014150 from the orig cell
gt; changed to 3014150, I then copied and pasted as value and still the cell
gt; showed 3014150. ???
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Use this formula to convert to TEXT, then copy PasteSpecial Values to get rid
gt; gt; of the formulas.........(use however many zeros you need).....
gt; gt;
gt; gt; =TEXT(A1,quot;0000000quot;)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Lauryquot; wrote:
gt; gt;
gt; gt; gt; I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
gt; gt; gt; to get these numbers into text format, but keep the lead zeros and I can't
gt; gt; gt; figure out how.
gt; gt; gt;
gt; gt; gt; When I double click on the cell, the zeros disappear. If I copy and paste
gt; gt; gt; to a text formatted cell, the zeros disappear. Any suggestions?

Add some more leading zeroes to Chuck's formula.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Lauryquot; gt; wrote in message
...
gt; Didn't work for me. I put in the formula and 00003014150 from the orig
cell
gt; changed to 3014150, I then copied and pasted as value and still the cell
gt; showed 3014150. ???
gt;
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; Use this formula to convert to TEXT, then copy PasteSpecial Values to
get rid
gt; gt; of the formulas.........(use however many zeros you need).....
gt; gt;
gt; gt; =TEXT(A1,quot;0000000quot;)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Lauryquot; wrote:
gt; gt;
gt; gt; gt; I have a column of numbers with lead zeros, formatted as Numer PESEL.
I need
gt; gt; gt; to get these numbers into text format, but keep the lead zeros and I
can't
gt; gt; gt; figure out how.
gt; gt; gt;
gt; gt; gt; When I double click on the cell, the zeros disappear. If I copy and
paste
gt; gt; gt; to a text formatted cell, the zeros disappear. Any suggestions?
Thank you so much! I thought you meant to put the # of zeros I needed at the
beginning - it works great and you just saved me a ton of manual work!

quot;CLRquot; wrote:

gt; You have to use the same number of zeros as characters in the original value
gt; (including the leading zeros).....in this case 11.......
gt;
gt; =TEXT(A1,quot;00000000000quot;)
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Lauryquot; wrote:
gt;
gt; gt; Didn't work for me. I put in the formula and 00003014150 from the orig cell
gt; gt; changed to 3014150, I then copied and pasted as value and still the cell
gt; gt; showed 3014150. ???
gt; gt;
gt; gt;
gt; gt; quot;CLRquot; wrote:
gt; gt;
gt; gt; gt; Use this formula to convert to TEXT, then copy PasteSpecial Values to get rid
gt; gt; gt; of the formulas.........(use however many zeros you need).....
gt; gt; gt;
gt; gt; gt; =TEXT(A1,quot;0000000quot;)
gt; gt; gt;
gt; gt; gt; Vaya con Dios,
gt; gt; gt; Chuck, CABGx3
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;Lauryquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
gt; gt; gt; gt; to get these numbers into text format, but keep the lead zeros and I can't
gt; gt; gt; gt; figure out how.
gt; gt; gt; gt;
gt; gt; gt; gt; When I double click on the cell, the zeros disappear. If I copy and paste
gt; gt; gt; gt; to a text formatted cell, the zeros disappear. Any suggestions?

Happy to help.........and thanks for the feedback.......

Vaya con Dios,
Chuck, CABGx3
quot;Lauryquot; wrote:

gt; Thank you so much! I thought you meant to put the # of zeros I needed at the
gt; beginning - it works great and you just saved me a ton of manual work!
gt;
gt; quot;CLRquot; wrote:
gt;
gt; gt; You have to use the same number of zeros as characters in the original value
gt; gt; (including the leading zeros).....in this case 11.......
gt; gt;
gt; gt; =TEXT(A1,quot;00000000000quot;)
gt; gt;
gt; gt; Vaya con Dios,
gt; gt; Chuck, CABGx3
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Lauryquot; wrote:
gt; gt;
gt; gt; gt; Didn't work for me. I put in the formula and 00003014150 from the orig cell
gt; gt; gt; changed to 3014150, I then copied and pasted as value and still the cell
gt; gt; gt; showed 3014150. ???
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot;CLRquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Use this formula to convert to TEXT, then copy PasteSpecial Values to get rid
gt; gt; gt; gt; of the formulas.........(use however many zeros you need).....
gt; gt; gt; gt;
gt; gt; gt; gt; =TEXT(A1,quot;0000000quot;)
gt; gt; gt; gt;
gt; gt; gt; gt; Vaya con Dios,
gt; gt; gt; gt; Chuck, CABGx3
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Lauryquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a column of numbers with lead zeros, formatted as Numer PESEL. I need
gt; gt; gt; gt; gt; to get these numbers into text format, but keep the lead zeros and I can't
gt; gt; gt; gt; gt; figure out how.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; When I double click on the cell, the zeros disappear. If I copy and paste
gt; gt; gt; gt; gt; to a text formatted cell, the zeros disappear. Any suggestions?