Try =TEXT(9506944.44444444,"£###,###,##0.00")

ryguy7272 wrote:
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!!!

--
Message posted via http://www.officekb.com