format a number concatenated with text

[jmwismer]

Hi there,

I have one cell value which is a number, say A1:3.5, and I have formatted the cell so that it shows 3.50.

I have another cell that contains text which also includes the number above:

="please pay the amount of " & A1 & " to the account..."

But then I lose the formatting (shows "..amount of 3.5 to..." instead of "..amount of 3.50 to..."). How can I force the formatting?

thx a lot,
jm

[Gary''s Student]

="please pay the amount of " & TEXT(A1,"0.00") & " to the account..."
--
Gary's Student


"jmwismer" wrote:

>
> Hi there,
>
> I have one cell value which is a number, say A1:3.5, and I have
> formatted the cell so that it shows 3.50.
>
> I have another cell that contains text which also includes the number
> above:
>
> ="please pay the amount of " & A1 & " to the account..."
>
> But then I lose the formatting (shows "..amount of 3.5 to..." instead
> of "..amount of 3.50 to..."). How can I force the formatting?
>
> thx a lot,
> jm
>
>
> --
> jmwismer
> ------------------------------------------------------------------------
> jmwismer's Profile: http://www.excelforum.com/member.php...o&userid=28201
> View this thread: http://www.excelforum.com/showthread...hreadid=515839
>
>

[jmwismer]

thx for your help, most appreciated!