convert dates to month

  • Thread starter Thread starter Mati
  • Start date Start date
M

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
 
with the value in A1 use:

=DATE(RIGHT(A1,4),--MID(A1,4,2),1) and format as mmmm,yyyy
 
date is not date format i guess,

try this

=TEXT(SUBSTITUTE(A1,".","/"),"mmmm,yyyy")
 
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.
 
Back
Top