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
|