View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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!!!