how to add comma to a formula
 

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

how to add comma to a formula
 

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" wrote in message
...

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

how to add comma to a formula
 

Thanks Bob! I worked wondefully.

"Bob Phillips" wrote in message
...
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" wrote in message
...

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