Append string to an Excel-cell, but ignore appended value when referenced in calculations?
Solution 1:
Use a custom format that adds the text to the end, like:
0 U\S\D
As you can see the USD does not truly exist in the value and as such it is still a number and can be used in mathematical equations.