Hi

Try
=TEXT(LEFT(A1,8),"dd mm yyyy")

--
Regards
Roger Govier



"juniper810" wrote in message
...
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?