You can't remove the day from a date in Excel. When you enter 1/13/2007 it
is converted to 39095 (you can see this by changing the format to a number).
Since dates are stored this way, you can't remove the day portion. If you
enter 1/2007, the cell may display something like Jan-07, but the value of
the cell is still 39083 (or 1/1/2007).

What are you trying to do with the dates that changing the format will not
work for you?

"charlie" wrote:

Thank you
I want it to be only the month and year in the field when I'm done so the
day is entirely gone.

"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