Is it possible to format part of a concatenated string?
For instance I have the following formula
=CONCATENATE(A5,G5)
This returns the following
Sales have decreased by -7260.39
The -7260.39 is the value of cell G5.
I want to be able to format this as Currency with no decimal points. However when included in the Concatenate string it returns the value as text. Is there anyway I can format it within the Concatenate string?