Kassie wrote:
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.

Thanks for the reply Kassie. Works but not quite as desired. The numbers
are a list of product numbers and the leading zeros vary. example
00011
0478
002
04258
Ended up just redoing the ones I needed to fix. I was just sure that I had
converted numbers like this before. Guess I was mistaken.

gls858