Does anyone out there know of a way to programmatically format a column as
currency in Excel? I'm able to create an Excel spreadsheet, but apparently the
data must be in string format to be exported, and it is printed as such in the
Excel spreadsheet. Formatting the spreadsheet's column as a currency column
after data export seems to be the answer, but I don't know the proper command
to do this. Any suggestions?
Does anyone out there know of a way to programmatically format a column as currency in Excel? I'm able to create an Excel spreadsheet, but apparently the data must be in string format to be exported, and it is printed as such in the Excel spreadsheet. Formatting the spreadsheet's column as a currency column after data export seems to be the answer, but I don't know the proper command to do this. Any suggestions?