| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do add text after the product within a formula?
ie... The sum of two cells is 256...
I want to put the word "dollars" after 256... and have the word there each time the number is updated. |
|
#2
|
|||
|
|||
|
=A1+B1&" dollars"
************ Anne Troy www.OfficeArticles.com "traybuddy" wrote in message ... ie... The sum of two cells is 256... I want to put the word "dollars" after 256... and have the word there each time the number is updated. |
|
#3
|
|||
|
|||
|
Thanks, Anne...
"Anne Troy" wrote: =A1+B1&" dollars" ************ Anne Troy www.OfficeArticles.com "traybuddy" wrote in message ... ie... The sum of two cells is 256... I want to put the word "dollars" after 256... and have the word there each time the number is updated. |
|
#4
|
|||
|
|||
|
traybuddy Wrote: ie... The sum of two cells is 256... I want to put the word "dollars" after 256... and have the word there each time the number is updated. =(A1+A2)&\" DOLLARS\" Regards. -- BenjieLop ------------------------------------------------------------------------ BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019 View this thread: http://www.excelforum.com/showthread...hreadid=475886 |
|
#5
|
|||
|
|||
|
Or, use a custom number format.
#,##0.00_)"thousand";[Red](#,##0.00)"thousand" If you do it this way, you can still perform calculations on this cell. "Anne Troy" wrote: =A1+B1&" dollars" ************ Anne Troy www.OfficeArticles.com "traybuddy" wrote in message ... ie... The sum of two cells is 256... I want to put the word "dollars" after 256... and have the word there each time the number is updated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Being treated as Text | Excel Worksheet Functions | |||
| Can I create and save a formula for text fields? | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
| Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) | |||
Linear Mode
