With the 'Accounting, format you'll get either a single space or - before the $ symbol, depending on whether the number is +ve or -ve. Plus you'll get however many spaces are needed to pad out the $ symbol from the first numeral to make the $ symbols line up. Either way, you'd need to allow the same amount of space (not number of spaces) in the cell, unless you have no -ve values; in which case a Find for ' $' replaced by '$' would delete that space. You'll also get a space after the last digit, which a wildcard Find/Replace could eliminate.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]