Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel 2002 Date Formatting
Assuming the date entered is "01.27.2005", I want to format as "JAN.2005"
(not "Jan.2005") - is this possible? |
#2
|
|||
|
|||
Can you use a helper cell and show the results there?
=UPPER(TEXT(DATEVALUE(SUBSTITUTE(A1,".","/")),"mmm.yyyy")) Worked ok with my USA date settings (mdy). substitute() changed the dots to slashes. datevalue() made it a real date text() changed it to Jan.2005 and upper() changed the case. skoladycz wrote: Assuming the date entered is "01.27.2005", I want to format as "JAN.2005" (not "Jan.2005") - is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2002 calcs slower than Excel 97 | Excel Discussion (Misc queries) | |||
Opening a Excel 2004 file in Excel 2002 | Excel Discussion (Misc queries) | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Auto date changing in Excel is maddening | Charts and Charting in Excel |