Combine a string and the result of an equation in a cell 2

[vestax22]

Hi, Using Excel 2000

I just want to know if it's possible to combine a string with the result of a function inside a cell? Here's an example of the result I want :

+- Result of a simple calculation

Hope this is clear and thx in advance

 

[DaleWatson123321]

This should work...

="+-"&A1


Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[DaleWatson123321]

Another, probably better option, is to format the cell...

Custom format... +- #,##0

Hope this helps

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[JPMontreal]

Hi,

Like that:

="Your salary is: " & TEXT(A1+B1,"$ 0.00&quot



Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca

 

[vestax22]

Thx Dale that did the trick