| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to Show month as text??
Surely this is possible....
I'm creating a gantt chart to use at work and want row 12 to be month and row 2 to be date Jan Jan Jan 1 2 3 etc. I'm able to derive months as numbers like this A1 is 1/1/2001 A2 is =MONTH(A1) However I can't then convert the result "1" into a text display "January." I've also tried Arrays 1 Jan 2 Feb 3 Mar etc Then using {=IF(array=array2, A2)} and various other permutations, but nothing seems to work... thoughts? Thanks :o) steve |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text entries behaving like numbers | Excel Discussion (Misc queries) | |||
| How do I get all text to show up and print all of it in cells? | Setting up and Configuration of Excel | |||
| Use a text box to calculate and show results in a user form | Excel Discussion (Misc queries) | |||
| HOW DO I SUMMARIZE A LIST OF TEXT, I WANT ONE A TO SHOW UP NOT 10 | Excel Worksheet Functions | |||
| HELP with this function | Excel Worksheet Functions | |||
Threaded Mode
