| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month(A1) in 2007
Hi All
I am trying to get just the year and month of a date to display and I am using =year(A1) =month(A1) the year is fine but the month appears as a number 1-12. I have tried changing the field to custom month but this just give the wrong answer. I can use a v-lookup to convert which is no problem but a bit messy (I remember in 2003 it worked fine) Any suggestions greatly appreciated cheers Rexmann |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| End of Month tic marks in Excel 2007 | Charts and Charting in Excel | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Excel 2003 month to month data change grid | Excel Discussion (Misc queries) | |||
| Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
| transfer cell $ amount to other sheet month-to-month without overc | Excel Discussion (Misc queries) | |||
Threaded Mode
