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

 

[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