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
|