Hi,

The problem with both of these solutions is, I have to manually edit
the "0.00" conditon in brackets to match the DP of the keycell. I want
this to be altered automatically via a keycell with a macro, but
obviously this is harder with TEXT formatting in the same formula.

Any other way to achieve this?

Cheers,

Aaron.


Teethless mama wrote:
Try this:

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


"Slashman" wrote:

Hi,

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

This cant be done with just TEXT formatting, because the numbers DP I
want isnt always going to be 30.00 sometimes it could be 30.0000 and I
would like to be able to have that automatically applied through a
macro, but can it be done by mixing text and number formatting?

Thanks in advance for any help,

Aaron.