Hello everyone,

Does anyone know how to add a comma to a formaula. For example:

-----
="( )$"&D7*2
-----

if d7 = 1000

then I would like the formula to return ( )$2,000

---
** Any help will be greatly apprecitated...

--
Himansu

Either use

=TEXT(D7*2,"""()""$#,##0")

or just use

=D7*2 and format the cell as ""()""$#,##0

--
HTH

Bob

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

"Himansu" <(E-Mail Removed)> wrote in message
news:O%(E-Mail Removed)...
>
> Hello everyone,
>
> Does anyone know how to add a comma to a formaula. For example:
>
> -----
> ="( )$"&D7*2
> -----
>
> if d7 = 1000
>
> then I would like the formula to return ( )$2,000
>
> ---
> ** Any help will be greatly apprecitated...
>
> --
> Himansu
>
>

Thanks Bob! I worked wondefully.

"Bob Phillips" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Either use
>
> =TEXT(D7*2,"""()""$#,##0")
>
> or just use
>
> =D7*2 and format the cell as ""()""$#,##0
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my
addy)
>
> "Himansu" <(E-Mail Removed)> wrote in message
> news:O%(E-Mail Removed)...
> >
> > Hello everyone,
> >
> > Does anyone know how to add a comma to a formaula. For example:
> >
> > -----
> > ="( )$"&D7*2
> > -----
> >
> > if d7 = 1000
> >
> > then I would like the formula to return ( )$2,000
> >
> > ---
> > ** Any help will be greatly apprecitated...
> >
> > --
> > Himansu
> >
> >
>
>