Posted to microsoft.public.excel.misc

Aditya

external usenet poster

Posts: 54

display month only

in cell A1 data is of 10 digit whose last 6 digit is in the form of ddmmyy.
i want to display only month name in cell B1

e.g. A1 B1
ACSD280509 MAY
RESG120309 MARCH

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
MONTH display	andrew	Excel Discussion (Misc queries)	6	July 11th 08 05:55 AM
Display each day of the month	WH99	Excel Discussion (Misc queries)	4	June 22nd 08 10:07 PM
I want a the to display the Month name only. Nothing else.	DAiuto	Setting up and Configuration of Excel	3	September 27th 07 12:19 AM
Display Month - 1	HearSay	Excel Worksheet Functions	10	September 30th 06 05:18 AM
Display every 3rd category name but still display latest month	maryj	Charts and Charting in Excel	1	September 24th 06 09:05 PM

All times are GMT +1. The time now is 12:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us