Wow! That's amazing! I will print and keep this one. Do you know how many
times I've wanted to do something similar!! I just don't know all these
little tricks!!
Thank you so much. Connie

"Per Jessen" wrote:

Hi

Select the column, then goto Format Cells Number Custum Type:
#######0000000 OK

Hopes this helps.

---
Per

On 8 Maj, 16:22, Connie Martin
wrote:
I have a column of numbers, over 800 rows. Some numbers are 7 digits and
some are 6 digits. I need a zero at the beginning of all the numbers with 6
digits. I have formatted the column to text so that I can do this because
it's not important that this column be recognized in number format. However,
is there a formula I could use to drag down the entire column that would pick
out all the numbers with 6 digits and throw a zero at the beginning of the
number? I'd hate to have to do this manually! Thank you. Connie