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