| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
In Excel, is there a way to enter dates in mm/yyyy format?
What I need is for the cell to remember the date as mm/yyyy. when I format
the cell to display this, it still puts the day in there even though it is not displayed. I need to be able to enter 05/06 and know that is a month and a day. I need also for Excel not to automatically assume that it is 05/06/2006. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, is there a way to enter dates in mm/yyyy format?
There are no dates without days thus you need to use text (precede the entry
with an apostrophe or format as text) Excel will always insert the current year whenever you enter something Excel interprets as a date without a year. So you need to enter a text representation of it -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Marshaann_82" wrote in message ... What I need is for the cell to remember the date as mm/yyyy. when I format the cell to display this, it still puts the day in there even though it is not displayed. I need to be able to enter 05/06 and know that is a month and a day. I need also for Excel not to automatically assume that it is 05/06/2006. Any suggestions? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
In Excel, is there a way to enter dates in mm/yyyy format?
If you do not want to go the text route you can add a column to the right of
your dates column and add the following formula =Month(A1)&"/"&Year(A1). Where A1 is the first cell containing a date value. -- Kevin Backmann "Peo Sjoblom" wrote: There are no dates without days thus you need to use text (precede the entry with an apostrophe or format as text) Excel will always insert the current year whenever you enter something Excel interprets as a date without a year. So you need to enter a text representation of it -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Marshaann_82" wrote in message ... What I need is for the cell to remember the date as mm/yyyy. when I format the cell to display this, it still puts the day in there even though it is not displayed. I need to be able to enter 05/06 and know that is a month and a day. I need also for Excel not to automatically assume that it is 05/06/2006. Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - cell format switches to custom when switching language | Excel Discussion (Misc queries) | |||
| Is there way to enter multiple values into excel cells w/ a form? | Excel Discussion (Misc queries) | |||
| How do I format a cell in MS Excel to enable me to enter a mobile. | Excel Discussion (Misc queries) | |||
| Ensure dates imported into Excel 2003 are shown in DD/MM/YYY form. | Excel Discussion (Misc queries) | |||
| how do I get excel to format dates before 1 jan 1900 | Excel Discussion (Misc queries) | |||
Linear Mode
