Show Two Decimal Places After Concatenation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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...
 
Beautiful!! Simply beautiful!!
I went with something like this:
=TEXT(MONTHS,"0.00")&" MONTHS " &EXPIRY_TEXT
 
Back
Top