convert dates to month

[Mati]

Need help to convert format "26.01.2008" to "January,2008". I have tried
formatting under dates etc and unfortunately it does not work.
Thanks,
Mati

 

[Gary''s Student]

with the value in A1 use:

=DATE(RIGHT(A1,4),--MID(A1,4,2),1) and format as mmmm,yyyy

 

[Mike H]

Hi,

If it's a correctly formatted date now then

Format|Cells|Custom

mmmm,yyyy

Mike

 

[muddan madhu]

date is not date format i guess,

try this

=TEXT(SUBSTITUTE(A1,".","/"),"mmmm,yyyy")

 

[Peo Sjoblom]

Try

=--SUBSTITUTE(A2,".","-")

and format as date

--


Regards,


Peo Sjoblom

 

[David Biddulph]

Your starting problem may well be that your 26.01.2008 is being regarded as
text, rather than as a date. If formatting the cell doesn't change the
value, then it's likely to be text. If that is so, use Data/ Text to
Columns, and specify DMY as the date format at the final stage of the
wizard, and it should be changed to a real date. Thereafter you can use
Format Cells to change the display to whichever date format you want, or
=TEXT(A2,"mmmm,yyyy") if you actually want to convert the value to text of
the specified format.

 

[Mati]

Thanks to all replies and particularly this one that worked like magic!
Mati