the use of the Ampersand "&"
="all " & (2+3) & " people"
will show as
all 5 people
If you want the number to be in a given format check the text() funciton in
help.
"Furrukh" wrote:
I am trying to display calculated value in a text string. The value could
change as the variables change.
|