Posted to microsoft.public.excel.misc

Russell

external usenet poster

Posts: 31

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting within a formula	WLMPilot	Excel Discussion (Misc queries)	5	September 8th 08 03:52 PM
formatting formula help!!!	Cam	Excel Discussion (Misc queries)	1	August 7th 08 08:10 PM
Formula formatting	pulling my hair out	Excel Discussion (Misc queries)	7	June 18th 07 08:17 AM
Formula Formatting	Cosmo[_2_]	Excel Discussion (Misc queries)	4	March 19th 07 10:19 PM
Formula / Formatting Help - please!"	Anthony	Excel Discussion (Misc queries)	4	July 21st 05 11:57 AM

All times are GMT +1. The time now is 09:06 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us