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