| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Confused
Did that, but it still shows January instead of March. Any thoughts?
"Teethless mama" wrote: In B1: =A1 (custom format as mmmm) "Dale" wrote: A:A has dates in it, formatted as Date, dd-mm-yyyy B:B I want to use =MONTH(A?). This works fine as it shows the month number, ie 3. My problem starts when I try to format B:B as mmmm and the cell shows January. What am I doing wrong? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Confused
The previous answer given will get the correct result so if you have
in B1: =A1 and B1 formatted as "mmmm" then it's the data. "Dale" wrote: Did that, but it still shows January instead of March. Any thoughts? "Teethless mama" wrote: In B1: =A1 (custom format as mmmm) "Dale" wrote: A:A has dates in it, formatted as Date, dd-mm-yyyy B:B I want to use =MONTH(A?). This works fine as it shows the month number, ie 3. My problem starts when I try to format B:B as mmmm and the cell shows January. What am I doing wrong? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Very confused.... | Excel Discussion (Misc queries) | |||
| Confused | New Users to Excel | |||
| confused,please help | Excel Discussion (Misc queries) | |||
| :S confused :S | Excel Discussion (Misc queries) | |||
| :S confused :S | Charts and Charting in Excel | |||
Linear Mode
