That did it. Thank you so much to the both of you.

Kyle


"JE McGimpsey" wrote:

If you follow the second part of Jim's suggestion, you don't need to
keep the additional column. Use the helper column to create the
formatted text, copy the column, then select your original column and
choose Edit/Paste Special, selecting the Values radio button. Delete the
"helper" column, and you're good to go.

In article ,
KeMet wrote:

Thanks, but I can't create another column. I am using this with some payroll
interface, so I need to save the .xls file as a .txt file. If I hide the
columns in excel, they still appear in the text file.

I'll keep trying, thanks.

Kyle


"Jim May" wrote:

create new helper column and enter:
=TEXT(A1*1000,"0000000")
You could also Copy and Paste-Special Value
to rid yourself of the formula afterwards..
Jim