Displaying zeros as dashes on a worksheet

I have a spreadsheet where there are several zeros. I would like the
zeros displayed as dashes (-) but would like this to happen without a
VBA function or sub. And, I still need to perform mathematical
operations on the cell value...so while it displays as a dash I would
like it to be recognized as a zero.

Can this be accomplished using the Format features through the
interface? Or am I out of luck and going to have to do this through
VBA?

Thanks for your help,
Eric

You should be able to do this using the Accounting format.


eschneide...@hotmail.com wrote:
> I have a spreadsheet where there are several zeros. I would like the
> zeros displayed as dashes (-) but would like this to happen without a
> VBA function or sub. And, I still need to perform mathematical
> operations on the cell value...so while it displays as a dash I would
> like it to be recognized as a zero.
>
> Can this be accomplished using the Format features through the
> interface? Or am I out of luck and going to have to do this through
> VBA?
>
> Thanks for your help,
> Eric

Eric,

This can be done with formatting under Format|Cells|Number. Select the
Custom format and type in something like the following:

0;0;-

The first format is for positive numbers, the second for negative numbers
and the third for zeros.

John Green

<eschneider71@hotmail.com> wrote in message
news:1113337655.974337.117010@o13g2000cwo.googlegroups.com...
>I have a spreadsheet where there are several zeros. I would like the
> zeros displayed as dashes (-) but would like this to happen without a
> VBA function or sub. And, I still need to perform mathematical
> operations on the cell value...so while it displays as a dash I would
> like it to be recognized as a zero.
>
> Can this be accomplished using the Format features through the
> interface? Or am I out of luck and going to have to do this through
> VBA?
>
> Thanks for your help,
> Eric
>

John Green wrote:
> Eric,
>
> This can be done with formatting under Format|Cells|Number. Select
the
> Custom format and type in something like the following:
>
> 0;0;-
>
> The first format is for positive numbers, the second for negative
numbers
> and the third for zeros.
>
> John Green
>
> <eschneider71@hotmail.com> wrote in message
> news:1113337655.974337.117010@o13g2000cwo.googlegroups.com...
> >I have a spreadsheet where there are several zeros. I would like
the
> > zeros displayed as dashes (-) but would like this to happen without
a
> > VBA function or sub. And, I still need to perform mathematical
> > operations on the cell value...so while it displays as a dash I
would
> > like it to be recognized as a zero.
> >
> > Can this be accomplished using the Format features through the
> > interface? Or am I out of luck and going to have to do this
through
> > VBA?
> >
> > Thanks for your help,
> > Eric
> >


Thanks for the replies - this is exactly what I was looking for!
Eric

This is a typical formatting question.

Click on "Format" from the top menu and choose "Cells". Select the "Number"
Tab and choose "Custom". (or you could choose "Accounting". A typical format
of this type would be:

#,##0.00_);-#,##0.00_);"-";@

"eschneider71@hotmail.com" wrote:

> I have a spreadsheet where there are several zeros. I would like the
> zeros displayed as dashes (-) but would like this to happen without a
> VBA function or sub. And, I still need to perform mathematical
> operations on the cell value...so while it displays as a dash I would
> like it to be recognized as a zero.
>
> Can this be accomplished using the Format features through the
> interface? Or am I out of luck and going to have to do this through
> VBA?
>
> Thanks for your help,
> Eric
>
>