Hello,
I am using the concatenate function in my worksheet.

=CONCATENATE("TOTAL QUOTE : £",H10,"")

I want the cost to have commas as in the original cell but it just appears
as a number.

I've tried Cell("contents",H10) but get the same result.

any ideas on how to get the commas?

Thanks