Well, you could use a helper column that returns a TEXT string.

A1 = 1/13/2007

=TEXT(A1,"m/yyyy")

Returns: 1/2007 as a TEXT string. This is not a numeric date and can cause
problems if you try to use it as a date in other calculations.

--
Biff
Microsoft Excel MVP


"charlie" wrote in message
...
I wish to change it forever not just format

"T. Valko" wrote:

Select the range of cells in question
Goto the menu FormatCellsNumber tab
Select Custom
In the little box under Type, enter:
m/yyyy
OK

--
Biff
Microsoft Excel MVP


"charlie" wrote in message
...
I would like to convert a column of dates to be just month and year