How do add text after the product within a formula?

traybuddy · 10-13-2005, 12:05 PM

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.

**BenjieLop** · 10-13-2005, 12:23 PM

Originally Posted by 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.

=(A1+A2)&" dollars"

Regards.

Anne Troy · 10-13-2005, 01:05 PM

=A1+B1&" dollars"
************
Anne Troy
www.OfficeArticles.com

"traybuddy" <[email protected]> wrote in message
news:[email protected]...
> 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.

traybuddy · 10-13-2005, 01:05 PM

Thanks, Anne...

"Anne Troy" wrote:

> =A1+B1&" dollars"
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "traybuddy" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>

Jonathan Cooper · 10-13-2005, 02:05 PM

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>