Formatting Excel Texts and Values

Hi!

I have a Form to be filled and i receive the data as .txt files, hence have to convert data from txt to excel format for the ease of copying to my target form easily.

Now i have managed to convert the file to excel, but certain formats are really confusing.
I would be grateful if someone could help me out.

I have attached the excel file with all descriptions.......

Regards

for others, cross-posted:
http://www.mrexcel.com/forum/excel-questions/766277-formatting-excel-texts-values.html
http://www.excelforum.com/excel-general/998950-formatting-excel-texts-and-values.html


for kjxavier some light reading: http://www.excelguru.ca/content.php?184