You are viewing this page out of context. To see it in the context it is intended please click here.

About This Page

Reply posted by Sam on Fri 18 Jan 2002 in response to Keeping the boss happy

Column formatting

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?