View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Russell Russell is offline
external usenet poster
 
Posts: 31
Default Formatting within Formula

Is it possible to apply formating to text within a formula. For example I
would like the "st" to be superscript.

=INT((MONTH(A2)+2)/3)&"st Quarter "&RIGHT(YEAR(A2),4)

Thanks in advance