| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date format only showing month year
When I type into a cell it autmatically reverts to a month/year format
instead of month/day. for instance, if I type in "may 5" it will change the date to May-01-2005. How can I get it to automatically select May-05-2007? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format only showing month year
Assuming cell is formatted as mmm-dd-yyyy type '5 may' (no quotes).
"nikkiabm" wrote: When I type into a cell it autmatically reverts to a month/year format instead of month/day. for instance, if I type in "may 5" it will change the date to May-01-2005. How can I get it to automatically select May-05-2007? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format only showing month year
Thanks Toppers - -but when I type in 5 may it still automatically selects the
date may-1-05 ... when I was hoping it would say may-5-07 ... and I'm not typing the quotes in here -- should have mentioned that! :) "Toppers" wrote: Assuming cell is formatted as mmm-dd-yyyy type '5 may' (no quotes). "nikkiabm" wrote: When I type into a cell it autmatically reverts to a month/year format instead of month/day. for instance, if I type in "may 5" it will change the date to May-01-2005. How can I get it to automatically select May-05-2007? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format only showing month year
Works OK for me (Excel 2003). If I type 5 may, it appears in the formula bar
as 05/05/2007 and in the cell as 05-may. So not sure why it is not working for you. (UK-based) "nikkiabm" wrote: Thanks Toppers - -but when I type in 5 may it still automatically selects the date may-1-05 ... when I was hoping it would say may-5-07 ... and I'm not typing the quotes in here -- should have mentioned that! :) "Toppers" wrote: Assuming cell is formatted as mmm-dd-yyyy type '5 may' (no quotes). "nikkiabm" wrote: When I type into a cell it autmatically reverts to a month/year format instead of month/day. for instance, if I type in "may 5" it will change the date to May-01-2005. How can I get it to automatically select May-05-2007? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
date format only showing month year
Have a look at the date formats in Windows Regional Settings.
-- David Biddulph "nikkiabm" wrote in message ... Thanks Toppers - -but when I type in 5 may it still automatically selects the date may-1-05 ... when I was hoping it would say may-5-07 ... and I'm not typing the quotes in here -- should have mentioned that! :) "Toppers" wrote: Assuming cell is formatted as mmm-dd-yyyy type '5 may' (no quotes). "nikkiabm" wrote: When I type into a cell it autmatically reverts to a month/year format instead of month/day. for instance, if I type in "may 5" it will change the date to May-01-2005. How can I get it to automatically select May-05-2007? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| Format date with just month and year | Excel Discussion (Misc queries) | |||
| I need date format to be set up as month/year. | New Users to Excel | |||
| day/month/year in incorrect format for date format | Excel Worksheet Functions | |||
| Month Year Date Format | Excel Worksheet Functions | |||
Linear Mode
