Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
Quick question. I am setting up a column with a date format and want to just
enter in the month and the year ie. 03/09. However when I enter this in it assumes that I am requesting for the current year and posts as 03/10 is displayed. 03/09/10 in the function field. Is there a way to do this and only enter in the month and year or do I need to enter in the full date 03/01/10? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
Unfortunately, when you enter only 2/3 of a date, Excel assumes you are
entering month and day. You have three choices: 1. Enter the full date 2. Use an event macro to change your entry 3. Use a helper column to convert your entry. The formula would be something like: =date(month(a1),day(a1),1) Regards, Fred "JLeCoure" wrote in message ... Quick question. I am setting up a column with a date format and want to just enter in the month and the year ie. 03/09. However when I enter this in it assumes that I am requesting for the current year and posts as 03/10 is displayed. 03/09/10 in the function field. Is there a way to do this and only enter in the month and year or do I need to enter in the full date 03/01/10? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
hi
this is excel being helpful and unless otherwize specified, excel always seems to assume the current year. it's filling in the gaps sort of. the only way i know to do it is to preceed the input with an apostrophe ('). excel will then view it as text and not be helpful anymore. regards FSt1 "JLeCoure" wrote: Quick question. I am setting up a column with a date format and want to just enter in the month and the year ie. 03/09. However when I enter this in it assumes that I am requesting for the current year and posts as 03/10 is displayed. 03/09/10 in the function field. Is there a way to do this and only enter in the month and year or do I need to enter in the full date 03/01/10? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking computer dates (time) to spreadsheet dates that have formu | Excel Worksheet Functions | |||
Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |