Maybe do this.........
Format column A as TEXT
Go ahead and enter 1/10, 1/10/05, etc etc down the column
In helper column B put this in B1 and copy down.........
=IF(LEN(A1)=6,TEXT(A1,"mm/dd/yyyy"),TEXT(A1,"mm/dd"))

Vaya con Dios,
Chuck, CABGx3


"Manta.ray" wrote in message
...
I have a specific need to show 'month and year' and 'day, month and year'
in
the same column. Because of multiple user input, I would like to make
this
as simple as possible. If they enter 1/05, I want to see January, 2005
and
if the enter 1/10/05, I want to see January 10, 2005. From what I can
see,
there is no way to format the entire column and acheive the stated goal.
One
must choose one format and customize/reformat individual cells, which
defeats
the purpose.

Any magic out there?