how do I change a date 1/13/2007 to 1/2007
 

I would like to convert a column of dates to be just month and year

how do I change a date 1/13/2007 to 1/2007
 

Use custom format m/yy, you cannot convert them since they would no longer
be dates but text
but you can change the display


--


Regards,


Peo Sjoblom


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

how do I change a date 1/13/2007 to 1/2007
 

Select the column of dates, click FORMAT and select CELL. Click the NUMBER
tab if necessary and in the CATEGORY list box, select CUSTOM and in the type
field create the following format code:

m/yyyy

Click OK to format the selected range
--
Kevin Backmann


"charlie" wrote:

I would like to convert a column of dates to be just month and year

how do I change a date 1/13/2007 to 1/2007
 

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

how do I change a date 1/13/2007 to 1/2007
 

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

how do I change a date 1/13/2007 to 1/2007
 

I want to change it not in format but as only being the month and year
without the day

"Peo Sjoblom" wrote:

Use custom format m/yy, you cannot convert them since they would no longer
be dates but text
but you can change the display


--


Regards,


Peo Sjoblom


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

how do I change a date 1/13/2007 to 1/2007
 

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

how do I change a date 1/13/2007 to 1/2007
 

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

how do I change a date 1/13/2007 to 1/2007
 

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

how do I change a date 1/13/2007 to 1/2007
 

See your new thread. [Why did you start a new thread rather than continuing
this one?]
--
David Biddulph

"charlie" wrote in message
...
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