How do add text after the product within a formula?

T

traybuddy

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.
 
B

BenjieLop

traybuddy said:
ie... The sum of two cells is 256...

I want to put the word "dollars" after 256... and have the word ther
each
time the number is updated.
Click to expand...

=(A1+A2)&\" DOLLARS\

Regards
 
J

Jonathan Cooper

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.
 
Top