Formatting Excel Texts and Values

[kjxavier]

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

[p45cal]

for others, cross-posted:
http://www.mrexcel.com/forum/excel-q...ts-values.html
http://www.excelforum.com/excel-gene...nd-values.html


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