| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formating | Excel Discussion (Misc queries) | |||
| Help with formating | Excel Discussion (Misc queries) | |||
| Formating | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Formating h:mm AM/PM | Excel Discussion (Misc queries) | |||
Linear Mode
