Hi

To convert number to text, use a formula such as =TEXT(A13,"0000000")in a
helper column - say B13, if the number is in A13. This is just an example,
you can use your desired text format for the number, eg with decimals, or the
number of leading zero's you want.
--
ve_2nd_at. Randburg, Gauteng, South Africa


"gls858" wrote:

I entered several numbers with leading zeros only to notice
after the fact that the leading zero's were being dropped as
expected. I then highlighted the numbers went to format and selected
text. The numbers all shifted to the left but the leading zeros
didn't appear. If I format a cell as text and them enter the number
the leading zeros appear. Is there no way to convert the ones that I
already entered? I thought for sure that I done this before without
a problem.

gls858