Maybe this

="Final cost " & TEXT(A6,"$0.00")

Mike

"Excel Challenged" wrote:

I have a value in one cell and I would like that value to update
automatically in my spreadsheet when it is changed. For instance, I have
$17.00 in cell A6 elsewhere in the spreadsheet I need to reference cell A6 in
a statement like "Final cost $17.00", having the $17.00 update if cell A6 is
changed to say $19.00. I am sure this possible with the right formula, but I
have not been able to get it to work. Any help would be appreciated.