Forum Discussion
Solved
Make cell value keep its Accounting format when placed in the middle of IF formula with text
Hello: Can you guys help me with this.... How can I make " & P2 &" keep its Accounting format when placed in the middle of IF formula with text? See formula below... IF(D1="Applicable", "and " ...
This is the idea:
="Total owed to you: "&DOLLAR(A1)You could also use TEXT which can handle dates if you're in a situation where you're concatenating those:
="Total owed to you: "&TEXT(A1,"$#,##0.00")
Thank you Patrick! That worked beautifully.
You're welcome!