We have an Excel 2007 sheet that has a series of values in Currency and Percentages. We are writing sentences and concatenating these values.
The problem is that the value is displayed unformatted.
How can we display the value formatted when in a concatenate string?
See the file attached. The cell has a format of $1,500.00, but when used in a sentences and the value concatenated, it displays 1500.