| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically convert Text with 2-digit year
Hi, I'm obtaining dates from another column using =left(a2,8). (This column
contains text following a date.) After I copy and paste special so that the values are displayed and not the formula, some dates are displayed as "Text with 2-digit year." This format does not allow these cells to be included when I filter. I know that I can convert each one manually, by clicking into each cell, or using "Convert XX to 20XX" but with the amount of cells that I'm working with, this will take forever! Is there an easier way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert dates to 8 digit text | Excel Discussion (Misc queries) | |||
| How do I convert Digit Number to Text in Excel ? | Excel Discussion (Misc queries) | |||
| Convert digit into text (alphabet) | Excel Discussion (Misc queries) | |||
| Addendum to 2 digit year to 4 digit year | Excel Discussion (Misc queries) | |||
| Format 2 digit year to 4 digit | Excel Discussion (Misc queries) | |||
Threaded Mode
