View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default 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!!!