Text Format for %

A

ainbinder

i have a fairly easy question that i can't find help for online or
hitting F1. I'm looking to use the TEXT formula to format a % and a $
amount so that if its negative, it shows up with parantheses.

Currently, my formula looks like this, and it gives me a negative sign
for negative numbers instead of the parantheses.

=TEXT(B38,"$#,#")&" / "&TEXT(B49,"0.0%")

Can someone point me in the right direction for this one? Ideally it
would be great if someone had a link to all the different ways we can
format TEXT! Thanks in advance for your help!

Adam
 
B

Bob Phillips

EXT(B38,"$#,#;($#,#)")&" / "&TEXT(B49,"0.0%;(0.0%)")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
R

Rick Rothstein \(MVP - VB\)

i have a fairly easy question that i can't find help for online or
hitting F1. I'm looking to use the TEXT formula to format a % and a $
amount so that if its negative, it shows up with parantheses.
Click to expand...

Here is a link to a help file that will explain what I think you were trying
find...

http://support.microsoft.com/default.aspx?id=264372

Look for the section entitled "Custom Number Formats".

Rick
 
Top