convert dates to month
 

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

convert dates to month
 

with the value in A1 use:

=DATE(RIGHT(A1,4),--MID(A1,4,2),1) and format as mmmm,yyyy
--
Gary''s Student - gsnu200809


"Mati" wrote:

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

convert dates to month
 

Hi,

If it's a correctly formatted date now then

Format|Cells|Custom

mmmm,yyyy

Mike

"Mati" wrote:

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

convert dates to month
 

date is not date format i guess,

try this

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


On Oct 22, 9:48*pm, Mati wrote:
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

convert dates to month
 

Try

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

and format as date

--


Regards,


Peo Sjoblom

"Mati" wrote in message
...
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

convert dates to month
 

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.
--
David Biddulph

"Mati" wrote in message
...
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

convert dates to month
 

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

"David Biddulph" wrote:

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.
--
David Biddulph

"Mati" wrote in message
...
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

convert dates to month
 

Glad it helped.
--
David Biddulph

"Mati" wrote in message
...
Thanks to all replies and particularly this one that worked like magic!
Mati

"David Biddulph" wrote:

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.
--
David Biddulph

"Mati" wrote in message
...
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