Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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

Show Two Decimal Places After Concatenation
 

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