Text Format for %

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ainbinder - 15 Nov 2007 16:56 GMT

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

Reply to this Message

Bob Phillips - 15 Nov 2007 17:20 GMT

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

Signature

HTH

Bob

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

>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 $
[quoted text clipped - 10 lines]
>
> Adam

Reply to this Message

Rick Rothstein (MVP - VB) - 15 Nov 2007 17:36 GMT

>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.

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

Reply to this Message

ainbinder - 15 Nov 2007 17:43 GMT

On Nov 15, 9:36 am, "Rick Rothstein $MVP - VB$"
<rickNOSPAMn...@NOSPAMcomcast.net> wrote:

> >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 $
[quoted text clipped - 8 lines]
>
> Rick

thanks everyone for your help! this worked perfectly and i have a
future reference! i appreciate it.

Reply to this Message