Using Classic ASP, I would like to format a few cells with Accounting formatting ($ left aligned, #.## right aligned + () for negative numbers). How would I accomplish that?

Thanks.

Hi! Please see this chapter in our online User Guide
http://www.easyxls.com/manual/basics/ex ... tting.html

I have reciewed that MANY times. I still can't figure out how to apply accounting formatting. I have been able to implement currency formatting, just not accounting format.

Please try to use ExcelStyle.setFormat("_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)") method.

This works PERFECTLY except when a cell contains a formula. is there a way to format cells with formulas?

Figured it out. Have apply the formatting BEFORE setting the values. Also, do you have a table of similar codes for other fomatting options?

You can do the formatting in Microsoft Excel.
Right click on the cell / Format Cells / choose your formatting / then select "Number" tab / "Custom" category.
Copy paste the characters in "Type:" textbox in your code.

but the whole point is to do it programatically lol. that is why we purchased the component - to export excel formatted the way we want.

You misunderstood. You are doing it programmatically. You are only using Microsoft Excel to find the predefined Excel formats. Then you are applying them, programmatically, with EasyXLS. The Excel number formats are unlimited and you can make unlimited combinations with them.