| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Month function
In using the month function I have encountered the following problem with
formatting. If I format the cells general or mm, I get the corresponding digit to reflect the correct month. However, If I use "mmm" or "mmmm", I get Jan or January no matter what month. How can I format this column using mmm or mmmm and get the correct result? I am using Office 2003. I would like to have the month spelled out instead of just the digit(s) that reflect the month. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function or formula to convert "text" month to number of month? | Excel Discussion (Misc queries) | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| function to fill all days of month to end of month | Excel Worksheet Functions | |||
| When using MONTH function on Blank Cell!! Returns Month=Jan! | Excel Discussion (Misc queries) | |||
| =Month function in Excel gives incorrect month | New Users to Excel | |||
Threaded Mode
