brilliant! worked like a charm...

Here's what I ended up using...

Range("B11:B65536").Select
Selection.TextToColumns Destination:=Range("B11:B65536"),
DataType:=xlDelimited, _
TextQualifier:=xlNone, ConsecutiveDelimiter:=False, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, OtherChar _
:="-", FieldInfo:=Array(1, 3), TrailingMinusNumbers:=True
Selection.NumberFormat = "dddd"

My range will always start at B11.

Thank you very much!

"Dave Peterson" wrote:

Your "dates" are plain old text.

Try converting them to real dates by:
Select the column
Data|Text to columns (in xl2003 menus)
Fixed width (but don't have any lines in the parsing window)
Choose Date (ymd)
And then finish up.

Then you should be able to reformat that column using any date format you want,
even:

dddd yyyy-mm-dd
or just plain
dddd



Stephen wrote:

Hi Folks,

I'm running a query and one of my columns returns a delivery date that is
formated as yyyy-mm-dd. Although the column is formatted as a general field,
I'm trying to changed the output to read Monday or Tuesday, etc. It seems
that due to the format of yyyy-mm-dd excel won't recognize this as a date
when I change the cells formatting.

I have a feeling I'm going to have to reformat the output to read mm/dd/yyyy
in order to then change it again to read Monday, Tuesday, etc. But I have
absolutely no idea where to start.

TIA!

--

Dave Peterson
.