Posted to microsoft.public.excel.worksheet.functions

Jman

external usenet poster

Posts: 110

Date question

I have in column A numbers 1-12 all representing the months in a year.
When i put in this formula =month(B1)
i get the numbers of the months... Is there a formula that gives me only the
NAME of the month, NOT the number.

A1 equals "2" how can this number be changed to say "feb" instead of 2?
B1 2-04-07

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
DATE Question	jlynn2000	Excel Discussion (Misc queries)	6	December 8th 06 03:43 PM
Date question	Bri	Excel Worksheet Functions	2	February 8th 06 02:36 AM
Date Question	nastech	Excel Discussion (Misc queries)	5	January 19th 06 09:40 PM
Date Question	John	Excel Discussion (Misc queries)	4	January 15th 06 06:33 PM
Another Date Question	Kdub via OfficeKB.com	Excel Discussion (Misc queries)	1	June 30th 05 01:09 AM

All times are GMT +1. The time now is 01:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us