I extend my thanks to everyone who got involved!


"John Bundy" wrote:

Here you go
=TEXT(A1,"£0.00")

--
-John
Please rate when your question is answered to help us and others know what
is helpful.


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