Cell Format & Dashes

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.

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.

"AngieM" wrote:

> 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.

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!

"bpeltzer" wrote:

> 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.
>
> "AngieM" wrote:
>
> > 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.

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

"AngieM" wrote:

> 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!
>
> "bpeltzer" wrote:
>
> > 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.
> >
> > "AngieM" wrote:
> >
> > > 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.

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.

"bpeltzer" wrote:

> Hmmm, I'm not seeing any alignment issue. Did you left in the asterisk and
> space that follow the third dollar sign?
>
> "AngieM" wrote:
>
> > 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!
> >
> > "bpeltzer" wrote:
> >
> > > 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.
> > >
> > > "AngieM" wrote:
> > >
> > > > 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.