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?