| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
converting text into years
Hi,
I have one column of text imported into excel that looks like column A data...I want to use a function that would give me whats in Column B, that is, the year of the last two characters in col A...I tried the year function and it worked for 1996-2000, but not for years 2001-2008...it gave me 2009 as a result. Any help appreciated very much Craig col A I want Col B to look like this: 01-00 2000 01-00 2000 01-00 2000 01-03 2003 01-01 2001 01-02 2002 01-07 2007 01-04 2004 01-08 2008 01-99 1999 01-98 1998 01-97 1997 01-96 1996 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem With Converting Days Months And Years | Excel Discussion (Misc queries) | |||
| Probem Of Converting Days Months And Years | Excel Discussion (Misc queries) | |||
| CONVERTING TIME (DAYS) TO ONTHS,YEARS, ETC. | Excel Worksheet Functions | |||
| Converting number of days to years and months | Excel Worksheet Functions | |||
| Converting months to years | Excel Worksheet Functions | |||
Threaded Mode
