Show Two Decimal Places After Concatenation

R

ryguy7272

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

Bernard Liengme

="£"&TEXT(A1,"#.00")
but this cannot be used in a calculation so why not format the cells as
needed?
best wishes
 
P

Pete_UK

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
 
S

squenson via OfficeKB.com

Try =TEXT(9506944.44444444,"£###,###,##0.00")
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!!!
Click to expand...
 
R

ryguy7272

Beautiful!! Simply beautiful!!
I went with something like this:
=TEXT(MONTHS,"0.00")&" MONTHS " &EXPIRY_TEXT
 
Top