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.