="This weight " &TEXT(A1,"#,##0.00")& " is in " & A2


Gord Dibben MS Excel MVP


On 4 Oct 2006 17:51:38 -0700, "Slashman" wrote:

Hi,

This prob on my spreadsheet is a pain and I hope there is a solution.

I have a cell that has a mixture of text and numbers. The text comes
through fine, but the numbers only come through as numbers whole ie 300
not 300.00.

EG:

="This weight "&A1&" is in "&A2

A1 is 300.00
A2 is g

The cell displays:

This weight 300 is in g

But I would like it to display:

This weight 300.00 is in g

Thanks for any advice,

Cheers,

Aaron.