Excel to text

I have a 5-column Excel file. I want to convert it to 4 fixed-width fields in a text file. The first 2 columns do not get transferred. The next is a SSN with hyphens; I want it 9(9). The next is a dollar amount which I want in 9(9).99. Then comes a single character which I want in XX. The last field required is a constant, the year, in 9999 format.