This is a simple straight forward task and I can't remember how to do
it.

When inserting a formula you can customise the output of a number,
however I can't remember to do it, I keep trying to use the CCUR
function found in most programming languages but I forget to remember
that this isn't in excel.

This is what I've got.

="TOTAL COST - "&(SUMIF(PC,"1200",Db))

Now the (SUMIF(PC,"1200",Db)) returns a number which I want to convert
to a currency whilst it's in the string, can someone be kind to me and
remind me how to do it. I've searched Microsoft's helpfiles and done
Google Groups search but I appear to be missing something.