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

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

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

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

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

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

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

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