Not the 'proper' way to do it (as there is still the fundamental problem),
but how about using

=TEXT(B2,"dddd")

--
__________________________________
HTH

Bob

"James" wrote in message
...
I downloaded a file into excel that has a column of dates (ex.,
10/20/2007).
I then formatted this column to the same date format. My goal is to have a
column that shows the corresponding day of week (ex., Saturday). In
another
cell (ex., C2), I entered "=B2" (the corresponding date) and did a custom
format as "dddd". But when I hit "enter", it returns the original
10/20/2007.
The kicker here is when I go into that cell and physically retype
"10/20/2007", then cell C2 shows what I'm looking for (Saturday). I don't
want to go in and retype all of the dates as there's many thousand. How do
I
fix?