Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 92

Confused

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 With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Confused	Dale	Excel Worksheet Functions	1	March 28th 07 12:21 AM
Confused	Karmen	New Users to Excel	4	February 24th 06 08:27 PM
confused,please help	shrutikhurana	Excel Discussion (Misc queries)	1	February 3rd 06 12:32 PM
:S confused :S	Laura \( '_' \)	Excel Discussion (Misc queries)	1	November 15th 05 01:44 PM
:S confused :S	Laura \( '_' \)	Charts and Charting in Excel	1	November 15th 05 01:44 PM

All times are GMT +1. The time now is 07:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us