| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formating MONTH()
Thanks to all. I got it. Can't use TEXT(Month( ),"mmmm") but TEXT ([date
cell],"mmmm") works just fine. "akphidelt" wrote: Suppose you have the date in A1 and you want to get the month name in B1... in b1 put the formula =Text(A1,"mmmm") "Matt S" wrote: How do I get Excel to display Jan instead of 1 - Nov instead of 11, etc. as the result for my = MONTH ( ) function? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating - How to emphsize the current Month | Excel Worksheet Functions | |||
| Formating - Date as Month In All Caps | Excel Worksheet Functions | |||
| how to change date formating-grouped by month in pivot table | Excel Discussion (Misc queries) | |||
| Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
| Conditional formating for the month | Excel Discussion (Misc queries) | |||
Threaded Mode
