="£"&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!!!