Thread: Formating
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default Formating
="month :"&TEXT(O3,"mmmm yyyy")
Regards,
Stefi


€˛Ling€¯ ezt Ć*rta:

my formula is ="month :"&O3
cell O3 is May 2008 however the result is Month : 39569
Is there a way i can get round this? i tried formating it to cell O3 but it
doesnt work.
Reply With QuoteReply With Quote