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.