Formating

Ling · May 30, 2008

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 · May 30, 2008

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

â€žLingâ€ ezt Ãrta:

Peo Sjoblom · May 30, 2008

Try

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

--

Regards,

Peo Sjoblom

Rick Rothstein \(MVP - VB\) · May 30, 2008

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

Formating

Ling

Stefi

Peo Sjoblom

Rick Rothstein \(MVP - VB\)