If you want to keep the value a real date, then you won't be able to do anything
to change what you see in the formulabar.

If you want to make the value a string, you could preformat the cell as text (or
start with a leading apostrophe) and type what you want.



Connie Martin wrote:

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

--

Dave Peterson