Cell Format & Dashes

[Guest]

I have a column of numbers. The first cell is formatted for accounting (with
$). If the amount is this cell is -0-, how do I keep from having a dash
inserted and still keep the $ sign in the cell? If I format the cell for
text, then it is tough to get the $ to line up with the $ in the sum.

 

[Guest]

Once you've got the accounting format selected, go back to Format > Format
Cells and select the Custom category. There you'll see the detailed
definition of the current format. Delete the three-character sequence "-" in
the section following the second semicolon.
I wound up with _($* #,##0.00_);_($* (#,##0.00);_($* ??_);_(@_) as the
custom format.

 

[Guest]

Okay, that takes care of the dash. However, the $ is right-aligned instead of
being left aligned with the sum $. Any fix for this? Thanks!

 

[Guest]

Hmmm, I'm not seeing any alignment issue. Did you left in the asterisk and
space that follow the third dollar sign?

 

[Guest]

Yes, this is what I have: _($* #,##0_);_($* (#,##0);_($* _);_(@_).

Your format shows "??" but mine doesn't. However, I tried adding the "??" to
mine and it fills the column with dollar signs.