a quick question about formatting

[vincentqin]

Hi,

In your template, you use $ in front of numbers in the first and last line, and use underline for summation. How do you get/define these formats in a quick way? Any shortcut? Thanks.

[wsthost]

Use our following macros (install the WST add-ins):

Ctrl+ Shift+D for dollar formatting
Ctrl+ Shift+M for number formatting ("money" macro)
Ctrl + U for underline (we overwrote excel's built-in Ctrl+U since in Excel 2007 and 2010 the underline changes the row height in most cases.