Tuesday, May 03, 2005

Excel's Custom Formats - Money formats

Great "How To" on how to make custom formats for money. I want the $ sign to go with the number, not way off on the left. A format that will do that seems to be: _($ #,##0_);[Red]_($ (#,##0);_($ "0"_);_(@_) with no decimal places and parens around negatives, or _($ #,##0.00_);[Red]_($ (#,##0.00);_($ "0.00"_);_(@_) for dollars and cents.

PC Magazine, Dec. 14, 2004, p. 95: Solution from PC Magazine: Excel's Custom Formats



<< Home

This page is powered by Blogger. Isn't yours?