Pivot Table Export Format Help

Is there a script or way to change the Format of Columns when exporting a pivot table? I'm exporting data using the Excel File option, and many of the columns I have formatted to Numbers, are being exported as TEXT when excel opens.