Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
You can get it to show MM/YY but you still have to input it all.
-- HTH Bob Phillips "tamato43" wrote in message ... Is there a way to format it correctly then? to just show Month year? "Bob Phillips" wrote: Yes, date input assumes you will start with the day (month in the US), and then assumes a month (day) and if you don't add a year it defaults to this year. -- HTH Bob Phillips "tamato43" wrote in message ... I'm rying to create a Month and Year (MM/YY) field on a spreadsheet to document expiration date. I've formatted the cell to show Month/Year (MM/YY, MM-YY, Mon-YY), but when I just enter month and year, e.g. 03/06, it defaults to Mar-05. Am I doing something wrong? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
Stop text from stringing into next field when empty | Excel Worksheet Functions | |||
save text field w/ leading zeros in .csv format & not lose zeros? | Excel Discussion (Misc queries) | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
Pivot Table Page Field | Excel Discussion (Misc queries) |