formatting/converting to .txt

Pjoaquin,

Thanks for your help in uploading the files.

There are a lot of values in these files, and some of the manual apostrophe adding and concatenating seems cumbersome and like there must be a better way.

If someone could help me with the leading zeroes issue, I'm sure I can just text to columns to eliminate the decimal point for the assumed decimal point file.

having a nice neat .txt come from the excel is also an issue.

Thanks,

Marko

Update - Hopefully someone can help me resolve this.

I can handle the decimal point with a text to columns, but only once all leading zeroes are in place. Simply Concatanating is a problem and what's hanging me up. When I Concatanate zeroes to a negative value, that minus sign remains in the middle and the file gets very messy very quick.

I can handle all spacing issues by just pushing the .xls file to a tab deliminated .txt and then doing find and replace to create spaces from the tabs.

Formatting these columns in Excel really has me hung up! Please help!

Maybe this is what you are looking for to put in the missing zeros:

=TEXT(E1,"000000.00")

And if you want to remove the desimal point:

=TEXT(E1*100;"00000000")

bjornar!

thank you. now we're working smarter and not harder!