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

P

Peo Sjoblom

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
 
K

Kevin B

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
 
T

T. Valko

Select the range of cells in question
Goto the menu Format>Cells>Number tab
Select Custom
In the little box under Type, enter:
m/yyyy
OK
 
C

charlie

I wish to change it forever not just format

T. Valko said:
Select the range of cells in question
Goto the menu Format>Cells>Number tab
Select Custom
In the little box under Type, enter:
m/yyyy
OK
Click to expand...
 
C

charlie

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

T. Valko

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.
 
C

charlie

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.
 
S

Sloth

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?
 
D

David Biddulph

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