YOu can change the cell format to display mmm-yy or mmmm-yyyy, etc, but that
doesn't affect what you see in the formula bar. It will still show the month,
day, and year.

On Wed, 9 Mar 2005 09:55:03 -0800, Jay wrote:

Is there a method that would convert any Date entered into a cell whether
it's 06/01/05 or June-2005 or 06/01/2005 or any other entry to June-05 (and
still be a valid date) and not show-up as 06/01/05 in the formula bar, but as
June-05 instead?