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