| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract the text between last comma and last but one comma. | Excel Worksheet Functions | |||
| Using comma inside the comma delimited text in Data Validation/Sou | Excel Programming | |||
| Comma Delimited-need comma at beginnng & end | Excel Discussion (Misc queries) | |||
| how do i concatenate a string and cell formula and use a comma? | Excel Worksheet Functions | |||
| how i use formula when i put the comma myself | Excel Discussion (Misc queries) | |||
Linear Mode
