| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formatting within Formula
Sorry, blank post. In a nutshell, no, it is not possible within a formula to
do as you are wanting. -- John C "John C" wrote: -- 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting within a formula | Excel Discussion (Misc queries) | |||
| formatting formula help!!! | Excel Discussion (Misc queries) | |||
| Formula formatting | Excel Discussion (Misc queries) | |||
| Formula Formatting | Excel Discussion (Misc queries) | |||
| Formula / Formatting Help - please!" | Excel Discussion (Misc queries) | |||
Linear Mode
