Hullo Everyone,

A quick question. I am trying to make all negative numbers come up as
zero with a dollar sign. I tried the ´general;"0" ' one but that
doesnt include the dollar sign. Any ideas or tips?

Thanks again,
MP

Did you already disqualify from the Worksheet menu bar:

Format, Cells, Number Tab, Currency?

Dan

Right, that throws up the $ sign, but I still need all negative
numbers to become 0´s. That's why I was thinking I need a type of
custom format.

On Jan 16, 5:10 pm, dan dungan <stagerob...@yahoo.com> wrote:
> Did you already disqualify from the Worksheet menu bar:
>
> Format, Cells, Number Tab, Currency?
>
> Dan

General;$"0"

Positive;negative;0;text
is the order of those pieces.

This doesn't change the value--it just changes the display.

"(E-Mail Removed)" wrote:
>
> Hullo Everyone,
>
> A quick question. I am trying to make all negative numbers come up as
> zero with a dollar sign. I tried the ´general;"0" ' one but that
> doesnt include the dollar sign. Any ideas or tips?
>
> Thanks again,
> MP

--

Dave Peterson

Hi MP and Dave,

When I enter General;$"0", the positive numbers are not formatted with
a dollar sign. Is that what you wanted?

Dan

Assuming your positive values are currency too... $0.00;$\0

Rick

<(E-Mail Removed)> wrote in message
news:cea9cb6f-a51d-494b-8db4-(E-Mail Removed)...
Hullo Everyone,

A quick question. I am trying to make all negative numbers come up as
zero with a dollar sign. I tried the ´general;"0" ' one but that
doesnt include the dollar sign. Any ideas or tips?

Thanks again,
MP

I forgot about zero.... $0.00;$\0;$0

Rick


"Rick Rothstein (MVP - VB)" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Assuming your positive values are currency too... $0.00;$\0
>
> Rick
>
> <(E-Mail Removed)> wrote in message
> news:cea9cb6f-a51d-494b-8db4-(E-Mail Removed)...
> Hullo Everyone,
>
> A quick question. I am trying to make all negative numbers come up as
> zero with a dollar sign. I tried the ´general;"0" ' one but that
> doesnt include the dollar sign. Any ideas or tips?
>
> Thanks again,
> MP

Well, I certainly learned something today.

Thanks Rick and Dave. . .and Michael for asking the original question.

Dan

The OP wasn't specific:

I am trying to make all negative numbers come up as
zero with a dollar sign. I tried the ´general;"0"

dan dungan wrote:
>
> Hi MP and Dave,
>
> When I enter General;$"0", the positive numbers are not formatted with
> a dollar sign. Is that what you wanted?
>
> Dan

--

Dave Peterson

Sorry for any miscommunication, I´ve come across that the original
value is still used in my total. Is there a way to change both the
value and the display. I was under the impression changing the display
would change the total if a negative number was present.

Thanks for the help-