I know there must be an easy solution to this, but I am trying to combine text and numerical cells into a single string while retaining the number format.
Example:
A1 = Based on
B1 = 5,000.00
C1 = dollars
D1 = A1 & " " & B1 & " " & C1
This returns "Based on 5000 dollars"
I would instead like it to return "Based on 5,000.00 dollars" (retaining the original numerical format).
How can I automate this?
Bookmarks