Help with txt and number

[chrisish]

Hi

I wondered if anyone can help in joining text and numbers already formated in to one cell.

<TABLE style="WIDTH: 179pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=238 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><COL style="WIDTH: 88pt; mso-width-source: userset; mso-width-alt: 4278" width=117><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 91pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=121 height=20>Total Paints are worth </TD><TD class=xl63 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 88pt; BORDER-BOTTOM: #e0dfe3; BACKGROUND-COLOR: transparent" align=right width=117>£750,891</TD></TR></TBODY></TABLE>

I have tried using CONCATENATE but I get this result without the number formated:

<TABLE style="WIDTH: 91pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=121 border=0><COLGROUP><COL style="WIDTH: 91pt; mso-width-source: userset; mso-width-alt: 4425" width=121><TBODY><TR style="HEIGHT: 15pt" height=20><TD class=xl65 style="BORDER-RIGHT: #e0dfe3; BORDER-TOP: #e0dfe3; BORDER-LEFT: #e0dfe3; WIDTH: 91pt; BORDER-BOTTOM: #e0dfe3; HEIGHT: 15pt; BACKGROUND-COLOR: transparent" width=121 height=20>Total Paints are worth 750891</TD></TR></TBODY></TABLE>

Please can someone help

Many Thanks

Chris

 

[Andrew Poulsom]

Welcome to MrExcel.

Use the TEXT function with the appropriate number format:

=A1&" "&TEXT(B1,"£#,##0")

 

[VoG]

Hi. Try like this

=A1&" "&DOLLAR(B1,0)

 

[chrisish]

Thanks guys for the quick response and solution

Chris