| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Format date with just month and year
I need to format a cell so the date automatically changes when the month changes. The output I need is 2/06 or 02/06 and when the month changes it should change to 3/06 or 03/06. Thank you -- Jay3253 ------------------------------------------------------------------------ Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955 View this thread: http://www.excelforum.com/showthread...hreadid=507745 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
"Jay3253" wrote in
message ... I need to format a cell so the date automatically changes when the month changes. The output I need is 2/06 or 02/06 and when the month changes it should change to 3/06 or 03/06. Thank you Have you tried clicking (on the menu) Format, Cells, and experimenting with what you see there? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
FormatCellsNumberCustom. In the Type box, enter m/yy
-- Kind regards, Niek Otten "Jay3253" wrote in message ... I need to format a cell so the date automatically changes when the month changes. The output I need is 2/06 or 02/06 and when the month changes it should change to 3/06 or 03/06. Thank you -- Jay3253 ------------------------------------------------------------------------ Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955 View this thread: http://www.excelforum.com/showthread...hreadid=507745 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
Thank you very much. I never even thought of that. :( -- Jay3253 ------------------------------------------------------------------------ Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955 View this thread: http://www.excelforum.com/showthread...hreadid=507745 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
From your post, maybe you should also consider the formula
=TODAY() Format as mm-yy HTH Kostis Vezerides |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
In Format Cells, enter either of these as a custom format:
To get 2/06: m/yy To get 02/06: mm/yy |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format date with just month and year
anyone know? -- Jay3253 ------------------------------------------------------------------------ Jay3253's Profile: http://www.excelforum.com/member.php...fo&userid=5955 View this thread: http://www.excelforum.com/showthread...hreadid=507745 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding month and year to form date | Excel Discussion (Misc queries) | |||
| Conditional Format (month and year) = Today() | Excel Worksheet Functions | |||
| How do I sort data by Month on the date format like (02/04/97)? | Excel Discussion (Misc queries) | |||
| counting date entries by month & year | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Hybrid Mode
