Formating

[Ling]

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.

 

[Stefi]

="month :"&TEXT(O3,"mmmm yyyy")
Regards,
Stefi


„Ling†ezt írta:

 

[Peo Sjoblom]

Try

="month :"&TEXT(O3,"mmmm yyyy")


--


Regards,


Peo Sjoblom

 

[Rick Rothstein \(MVP - VB\)]

Change your formula to this...

=O3

and Custom Format the cell using (exactly) this...

"Month: "mmm yyyy

or this...

"Month: "mmmm yyyy

depending on whether you want the month name abbreviated or spelled
completely out.

Rick