| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change from mm/dd/yy to yy/mm
Hi,
I have a column with date field in mm/dd/yy format (about 1000 rows). I would like to duplicate the date field in another column, but convert to Year/Month (yy/mm). For example: The new column will delete/ignor the dd format. 04/21/08 count as 08' APR or 08' 04 04/05/08 count as 08' APR or 08' 04 06/15/08 count as 08' JUN or 08' 06 Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
| Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| making copied cells change with change in original cell | Excel Worksheet Functions | |||
| change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) | |||
Threaded Mode
