Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pasting a chart from Excel 2007 to Word 2007 trouble | Charts and Charting in Excel | |||
Date Question - 12/1/2007 & "through" & 12/31/2007 | Excel Discussion (Misc queries) | |||
Exporting Quickbooks 2007 to Excel 2007 | Excel Worksheet Functions | |||
Change menu's and toolbars in 2007 | New Users to Excel | |||
Office 2007 Pro Plus 2007 (Beta) - getting small red and green arr | Excel Discussion (Misc queries) |