formatting/converting to .txt

[pavemar]

hello all,

I can sure use some help. I have Excell files that I need in .txt format, the format is quite particular.

Leading zeroes - I know I can add apostrophe and use concatanate to come extent, but there are a LOT of values in these files and I'm really stumped on how I can do this en masse.

Another issue is that decimal values are to be assumed in one of the text files (534.33 = 00000053433) and I'm not sure of the best way to do this.

Also, I'm not sure of a smart way to ensure the files are spaced properly on the created .txt file.

I've attached sample files. The sample .txt files are what I need to create from the values in my excel files.

Thanks in advance!