The same way you would any other font object in Excel. I'm not being mean about this. What I am saying is that all object in Excel are basically visible to the Object Model. Example:

Code:
ActiveSheet.PageSetup.CenterHeader
And once you get to an object, you can modify it's attributes/parameters the same way. Example:

Code:
objExcelQuote.Selection.NumberFormat = "$#,##0.0000"
So...if you put both of what I said together, you'll be able to do this, I assure you. Laters, Jeremy