Convert Month Display

Posted to microsoft.public.excel.misc

external usenet poster

Posts: 48

Convert Month Display

How to convert the month in number to the month in text ?
For example :

in cell A1 enter 2
in cell B1 display February 2009

Thanks,

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
display month only	aditya	Excel Discussion (Misc queries)	4	May 29th 09 08:16 AM
Function or formula to convert "text" month to number of month?	Steve Vincent	Excel Discussion (Misc queries)	5	May 15th 07 01:11 AM
Display every 3rd category name but still display latest month	maryj	Charts and Charting in Excel	1	September 24th 06 09:05 PM
Function or formula to convert "text" month to number of month?	Kevin Vaughn	Excel Discussion (Misc queries)	0	February 4th 06 04:45 PM
Function or formula to convert "text" month to number of month	Steve Vincent	Excel Discussion (Misc queries)	1	February 4th 06 04:19 PM

All times are GMT +1. The time now is 04:13 PM.

About Us