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

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

You can do this with the TEXT function. I've kept the currency symbol
separate so you can easily change it:

="£"&TEXT(A1,"0.00")

or you can include it within the format string:

=TEXT(A1,"£0.00")

Hope this helps.

Pete

On Aug 2, 2:38Â*pm, 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!!!

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

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

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

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