Continuation of formatting percentages

[trishnaha]

I have now corrected the formatting for negative percentages showing the % sign. My next question is the areas where I do not want the percent sign to show and so my figures align right I have been formatting them as #.00_% but then when I have a negative using this format I get the minus sign and I want the number to be formatted (1.77)not -(1.77). How do I correct this.

[Mark W.]

#.00_);(#.00)

tishnaha, you really need to take a look at the Excel Help topic for "Custom number, date, and time format codes" to become self-reliant.

[trishnaha]

Thank you for your help but your answer really didn't need an attitude. This site was meant for questions not attitudes. If I post a question again, kindly don't answer. Thank You
On 2002-05-17 12:11, Mark W. wrote:
#.00_);(#.00)

tishnaha, you really need to take a look at the Excel Help topic for "Custom number, date, and time format codes" to become self-reliant.

[Mark W.]

No attitude... just the facts, ma'am. You've posted twice in the span of 2 days on the same topic -- formatting negative percentages.

Oops! I answered.

[ This Message was edited by: Mark W. on 2002-05-21 08:56 ]

[trishnaha]

Well you think you know it all it may have formatted the percentages correctly but you did a lousy job on the alignment. Of course in your case your mouth is much bigger than your brains. Now get on with life and let us people that sometimes need help use this site for what it was meant for. I will no longer use any of my energy to put up with your smart attitude. Why don't you go into a chat room where you belong.
On 2002-05-21 07:22, Mark W. wrote:
No attitude... just the facts, ma'am. You've posted twice in the span of 2 days on the same topic -- formatting negative percentages.

Oops! I answered.

[ This Message was edited by: Mark W. on 2002-05-21 08:56 ]