="£"&TEXT(A1,"#.00")
but this cannot be used in a calculation so why not format the cells as
needed?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ryguy7272" wrote in message
...
The value below is generated by a function. I used the "&" symbol to
concatenate the "£" with the value. Sometimes I use a "$" and sometimes I
use a "?". Now, I'm trying to show just two decimal places.

£9506944.44444444

Can someone please help out?
TIA!!!

Beautiful!! Simply beautiful!!
I went with something like this:
=TEXT(MONTHS,"0.00")&" MONTHS " &EXPIRY_TEXT


"Bernard Liengme" wrote:

="£"&TEXT(A1,"#.00")
but this cannot be used in a calculation so why not format the cells as
needed?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ryguy7272" wrote in message
...
The value below is generated by a function. I used the "&" symbol to
concatenate the "£" with the value. Sometimes I use a "$" and sometimes I
use a "?". Now, I'm trying to show just two decimal places.

£9506944.44444444

Can someone please help out?
TIA!!!

So, how does that tie in with your original question about currency?

Pete

On Aug 2, 3:18 pm, ryguy7272
wrote:
Beautiful!! Simply beautiful!!
I went with something like this:
=TEXT(MONTHS,"0.00")&" MONTHS " &EXPIRY_TEXT