Custom Cell Format Question

[MichaelPaul.Hernandez]

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

 

[dan dungan]

Did you already disqualify from the Worksheet menu bar:

Format, Cells, Number Tab, Currency?

Dan

 

[MichaelPaul.Hernandez]

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.

 

[Dave Peterson]

General;$"0"

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

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

 

[dan dungan]

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

 

[Rick Rothstein \(MVP - VB\)]

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

Rick

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

 

[Rick Rothstein \(MVP - VB\)]

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

Rick

 

[dan dungan]

Well, I certainly learned something today.

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

Dan

 

[Dave Peterson]

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"

 

[MichaelPaul.Hernandez]

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-

 

[Rick Rothstein \(MVP - VB\)]

Well, I certainly learned something today.

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

http://msdn2.microsoft.com/en-us/library/aa263409(VS.60).aspx

Rick