INSERT COST

[Stuart Carnachan]

I wish to insert a costing pulled from a cell in a worksheet into a word
sentence as below

All for the price of ????

 

[Allllen]

Try something like this

="All for the price of "&TEXT(A2,"$0.00")

with your value in cell A2.

HTH