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..."

 

[jmwismer]

thx for your help, most appreciated!