Saving Formats as Named Styles
Although Excel's named styles are considerably less versatile than their equivalents in Word, you can still use this feature to reuse favorite formats. By default, every new workbook includes a set of predefined formats in the following named styles: Normal, Percent, Currency, Comma, Currency [0], and Comma [0]. (The two styles followed by [0] show whole numbers only rather than two decimal places.)
Tip from 
The Currency, Percent, and Comma buttons on Excel's Formatting toolbar actually apply the corresponding named styles. If you want to redefine any of these buttons, just redefine that style. The Currency button, ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
