Thread: date format
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen Stephen is offline
external usenet poster
 
Posts: 106
Default date format

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!