| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date format
How would we get 2008-01 to read as "Jan-08"?, etc for months and
years. I'd use a helper column if necessary. Custom format is better though. TIA. Pierre |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
Type the following in to the custom format:
mmm-yy "Pierre" wrote: How would we get 2008-01 to read as "Jan-08"?, etc for months and years. I'd use a helper column if necessary. Custom format is better though. TIA. Pierre |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
On Jan 16, 9:57*am, Sam Wilson
wrote: Type the following in to the custom format: mmm-yy Sam, thanks for the reply. Couldn't get it to work though. Pierre |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
It looks like 2008-01 is taken as text by Excel, so changing the
format of the cell will not work - instead, you will need a formula in a helper cell, such as: =DATE(LEFT(A1,4),RIGHT(A1,2),1) and then format this cell using the custom format of mmm-yy. Copy the formula down if you have many such entries. Hope this helps. Pete On Jan 16, 4:13*pm, Pierre wrote: On Jan 16, 9:57*am, Sam Wilson wrote: Type the following in to the custom format: mmm-yy Sam, thanks for the reply. *Couldn't get it to work though. Pierre |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
On Jan 16, 10:21*am, Pete_UK wrote:
It looks like 2008-01 is taken as text by Excel, so changing the format of the cell will not work - instead, you will need a formula in a helper cell, such as: =DATE(LEFT(A1,4),RIGHT(A1,2),1) and then format this cell using the custom format of mmm-yy. Copy the formula down if you have many such entries. Hope this helps. Pete Pete: it worked like a charm. Thank you. Pierre |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
You're welcome - thanks for feeding back.
Pete "Pierre" wrote in message ... On Jan 16, 10:21 am, Pete_UK wrote: It looks like 2008-01 is taken as text by Excel, so changing the format of the cell will not work - instead, you will need a formula in a helper cell, such as: =DATE(LEFT(A1,4),RIGHT(A1,2),1) and then format this cell using the custom format of mmm-yy. Copy the formula down if you have many such entries. Hope this helps. Pete Pete: it worked like a charm. Thank you. Pierre |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date format
DataText to ColumnsNextNextColumn Data FormatDateYMDFinish.
Gord Dibben MS Excel MVP On Wed, 16 Jan 2008 07:36:26 -0800 (PST), Pierre wrote: How would we get 2008-01 to read as "Jan-08"?, etc for months and years. I'd use a helper column if necessary. Custom format is better though. TIA. Pierre |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert European Date format to American Format | Excel Discussion (Misc queries) | |||
| Convert date from text format to date format | Excel Discussion (Misc queries) | |||
| Convert date + time text format to date format | Excel Worksheet Functions | |||
| Can I change a date with no format (20051111) to date format? | New Users to Excel | |||
| Excel 2000 date format cannot be set to Australian date format | Excel Discussion (Misc queries) | |||
Linear Mode
