View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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