How to convert MM/DD/YYYY to Month

S

siva

Folks,

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

Sivaji Chelliah
 
T

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)
 
M

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.
 
B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top