View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
davesexcel davesexcel is offline
external usenet poster
 
Posts: 1
Default displaying fractions in a concatenate formula


davesexcel Wrote:
="The Average of "&A1&" and "&A2&" "&"is= "&TEXT(((A1+A2)/2),"#?/?")
Okay I am getting closer I am now at 7/2
still working on the format

Oh,
I see dave got it


--
davesexcel


------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=564534