Thread: Formatting within Formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
John C[_2_] John C[_2_] is offline
external usenet poster
  
Posts: 1,358
Default Formatting within Formula

--
John C


"Russell" wrote:

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
Reply With QuoteReply With Quote