Month Names

B

bat17

Well-known Member

Joined

Aug 15, 2003

Messages

1,470

• Sep 19, 2003

• #2

Just set the format of the cel to "MMMM"

HTH

Peter

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 19, 2003

• #3

Try this

=TEXT("1/"&A2+0,"mmmm")

where A2 has the month number.

 

Upvote 0

M

Mark W.

MrExcel MVP

Joined

Feb 10, 2002

Messages

11,654

• Sep 19, 2003

• #4

Or...

=TEXT((A1&"/1")+0,"mmmm")

 

Upvote 0

J

Juan Pablo González

MrExcel MVP

Joined

Feb 8, 2002

Messages

11,959

• Sep 19, 2003

• #5

Mark W. said:

Or...

=TEXT((A1&"/1")+0,"mmmm")

Click to expand...

Right ! I'm always thinking in "my" system, dd/mm/yyyy, not the US system...

 

Upvote 0

Andrew Poulsom

MrExcel MVP

Joined

Jul 21, 2002

Messages

73,092

• Sep 19, 2003

• #6

Juan Pablo González said:

Mark W. said:

Or...

=TEXT((A1&"/1")+0,"mmmm")

Click to expand...

Right ! I'm always thinking in "my" system, dd/mm/yyyy, not the US system...

Click to expand...

I think that's very sensible. Who in their right mind would want to put the month before the day? :wink:

 

Upvote 0