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


"Ling" wrote in message
...
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.