concatenate with numbers

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

="TOTAL QUOTE : "&TEXT(H10,"£#,##0")

--
HTH

Bob Phillips

"Ciara" <[email protected]> wrote in message
news:[email protected]...
> 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

Thank you!

"Bob Phillips" wrote:

> ="TOTAL QUOTE : "&TEXT(H10,"£#,##0")
>
> --
> HTH
>
> Bob Phillips
>
> "Ciara" <[email protected]> wrote in message
> news:[email protected]...
> > 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
>
>
>