ExcelBanter - INSERT COST

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - INSERT COST (https://www.excelbanter.com/excel-discussion-misc-queries/108093-insert-cost.html)

Stuart Carnachan

INSERT COST

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

All for the price of ????
--
Stuart

Allllen

INSERT COST

Try something like this

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

with your value in cell A2.

HTH
--
Allllen

"Stuart Carnachan" wrote:

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

All for the price of ????
--
Stuart

All times are GMT +1. The time now is 04:19 AM.