| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MM/YY Formatting date Entry AND Display
I went into formatting for a cell and entered MM/YY.
When I enter i.e. "3/09" it displays 03/10 (meaning 3/9/2010). It appears that if I enter any number between 1 & 31, it assumes it's the DAY. If I enter 3/32, it works and displays 03/32 (meaning 3/01/2032). So how do I format the number so that it knows the digits I enter are going to be month then year. Is there a way to default it to always know the day will be 01? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
| how can i display the date and time of a cell entry in excel? | Excel Discussion (Misc queries) | |||
| How do I display the last entry in a list | New Users to Excel | |||
| formatting a cell to display the correct date. | Excel Discussion (Misc queries) | |||
| display last entry in Excel | Charts and Charting in Excel | |||
Threaded Mode
