H Himansu Jun 30, 2008 #1 Hello everyone, Does anyone know how to add a comma to a formaula. For example:
B Bob Phillips Jun 30, 2008 #2 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)
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)
H Himansu Jun 30, 2008 #3 Thanks Bob! I worked wondefully. Bob Phillips said: 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) Click to expand...
Thanks Bob! I worked wondefully. Bob Phillips said: 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) Click to expand...
