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