How to convert MM/DD/YYYY to Month

[siva]

Folks,

Help me out in converting "MM/DD/YYYY HH:MM:SS" format to a "Month"
Format

Sivaji Chelliah

 

[teylyn]

If you want the month number, use

=Month(A1)

if you want the month name, use

=text(a1,"mmmm")

hope that helps

teylyn
'The Code Cage - Microsoft Office Help - Microsoft Office Discussion
(http://www.thecodecage.com)

 

[Mike H]

Hi,

Format as
mmm

for jan, feb etc

or
mmmm

for January, February etc
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

 

[Bryce]

You can change the cell formating to another custom format.
Under the Format Cells -> Number tab is the "Category:" list. The last
option is Custom. Selecting this shows a "Type:" list of available custom
types.

This list can be added to, by overwriting what is in the "Type:" box.
Add mmm for Jan, Feb etc or mmmm for full month names

I often use ddd dd mmm yyyy for "Sun 21 Feb 2010"

The sample box updates as you type, so for example using that date:
m = 2
mm = 02
mmm = Feb
mmmm = February