Can anyone tell me how to change this code for the NumberFormat, such
that with any of the various currencies, the display will appear with
the currency symbol on the far left of the cell, the resulting figure
is displayed to the far right of the cell, no decimal places are shown
(think I
have that part solved), and zero's are displayed only as dashes?
This
is done ordinarily in the worksheet just by choosing Accounting
format
and checking the appropriate boxes.. I tried using that string :

_($* #,##0_);_($* (#,##0);_($* "-"_);_(@_)


without the $, so that line of code looks like so:


Me.Range("F49:AF49").NumberFormat
= Mid$(cv, 5, 1) & "_(* #,##0_);_(* (#,##0);_(* " - "_);_(@_)"


I imagine it's simple, but it is beyond me for the moment.

Thanks,

Troy