Select row 1 and convert to text

[MartinL]

I have a sheet that come to me each month that contains some key data in columns 1 to 3 and then a series of dates in columns 4 to 100. with all the numeric values below - around 100k rows
next month it will be from 4 to 101
the following month from 4 to 102 and so on
i.e. the number of columns is dynamic

I need the month to be the header so that I can un-pivot the data, but as you cannot have a date field as a header the top row needs to be converted to a text field.
If I do this now everything else works just fine and dandy but the following month the last date field does not get converted as it could not be previously selected.

What I feel I need is to select row 1 and convert it to text then Use first row as headers but I have not found a way to convert row 1 to text so I can do this.

Has anyone else found a way around this, or can suggest a way.

example data

Excel Workbook
	A	B	C	D	E	F	G	H	I
1	Column1	Column2	Column3	Column4	Column5	Column6	Column7	Column8	Column9
2	Region-SKU	Region	SKU	01/01/2016	01/02/2016	01/03/2016	01/04/2016	01/05/2016	01/06/2016
3	R01BJSUVXDWQHZZ	R01	BJSUVXDWQHZZ	3	7	12	6	9	3
4	R01YMOJACLMLJRW	R01	YMOJACLMLJRW	20	27	11	18	15	21
5	R01CDLKXGCGGUFM	R01	CDLKXGCGGUFM	12	8	2	3	7	8
6	R01TVMXPYGZNRDH	R01	TVMXPYGZNRDH	3	2	4	0	1	3
7	R01HVUWGMAVFIZT	R01	HVUWGMAVFIZT	0	0	0	0	0	0
8	R01POKDJLFYIWMH	R01	POKDJLFYIWMH	0	0	0	0	0	0
9	R01GZXAOQSBKMZA	R01	GZXAOQSBKMZA	0	0	0	0	0	0
10	R01SBTVZUTNONBD	R01	SBTVZUTNONBD	2	1	1	1	1	2
Sheet1