Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I format a date so that when I type 8-4, it gives Aug-04, or when I
type 5-3 it gives May-03. This is month and year. I can use a work-around and custom format mm/dd which gives me in the printed form what I want, but when you click in the cell it will shows 8/4/2005 in the formula bar. This is a month and year format and I want it to reflect nothing more in the formula bar. If 8-4 is August 2004, I want it to give me 8/04 in the cell, but something in the formula bar showing that this is month and year, i.e. 8/2004. Hope I have explained myself. If I format mm/yy, then I have to type in a day, i.e. 8-8-4 will give me 08/04, but I don't want a day reflected in the formula bar, neither do I want to type a day. Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare dates (one cell not in date format) | Excel Discussion (Misc queries) | |||
How do I keep the date from changing format in a mail merge? | Excel Discussion (Misc queries) | |||
Date format | Excel Discussion (Misc queries) | |||
USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
Date format collapses diagram | Excel Discussion (Misc queries) |