How can we format a value to Currency when used in a concatenate string
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.
FormatCurrency.withString.xlsx
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.
FormatCurrency.withString.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanx
ASKER