ExcelBanter - Formating

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formating (https://www.excelbanter.com/excel-discussion-misc-queries/189354-formating.html)

Ling

Formating

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

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.

Peo Sjoblom

Formating

Try

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

--

Regards,

Peo Sjoblom

"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.

Rick Rothstein \(MVP - VB\)[_577_]

Formating

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.

All times are GMT +1. The time now is 01:55 AM.