I have a pretty simple worksheet that lists the date in column A.

In column B, I have a formula that converts the date in Column A to
the proper day of week.

When I put it in a pivot table, it treats column B as an individual
date, not the proper DOW.

I attempted to copy/paste special/values into a new column, but it
doesn't change it to the DOW, it leaves it as the date.

I am trying to get Excel to permanently change the cells in column B
to say "Tuesday" instead of 4/19/07.

Does that make sense? All of the conventional answers don't seem to
work for me. Any help?

It would certainly help if you posted the Col_B formula you're using.

Absent that, try something like this:
B1: =TEXT(A1,"dddd")

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)


"Hoek" <(E-Mail Removed)> wrote in message
news:a67ba4ed-0e4d-4939-a2d1-(E-Mail Removed)...
> I have a pretty simple worksheet that lists the date in column A.
>
> In column B, I have a formula that converts the date in Column A to
> the proper day of week.
>
> When I put it in a pivot table, it treats column B as an individual
> date, not the proper DOW.
>
> I attempted to copy/paste special/values into a new column, but it
> doesn't change it to the DOW, it leaves it as the date.
>
> I am trying to get Excel to permanently change the cells in column B
> to say "Tuesday" instead of 4/19/07.
>
> Does that make sense? All of the conventional answers don't seem to
> work for me. Any help?
>

Ron, thanks for the response.

I tried your suggestion (which I had tried before) and it worked this
time, I just hadn't gone the extra step to paste the values only.

Next time I will use the formula to change the format instead of the
"format cells" option.

Thanks!

On May 9, 12:04 pm, "Ron Coderre" <ronREMOVETHIScode...@bigfoot.com>
wrote:
> It would certainly help if you posted the Col_B formula you're using.
>
> Absent that, try something like this:
> B1: =TEXT(A1,"dddd")
>
> Is that something you can work with?
> Post back if you have more questions.
> --------------------------
>
> Regards,
>
> Ron
> Microsoft MVP (Excel)
> (XL2003, Win XP)
>
> "Hoek" <spoonerstr...@gmail.com> wrote in message
>
> news:a67ba4ed-0e4d-4939-a2d1-(E-Mail Removed)...
>
> > I have a pretty simple worksheet that lists the date in column A.
>
> > In column B, I have a formula that converts the date in Column A to
> > the proper day of week.
>
> > When I put it in a pivot table, it treats column B as an individual
> > date, not the proper DOW.
>
> > I attempted to copy/paste special/values into a new column, but it
> > doesn't change it to the DOW, it leaves it as the date.
>
> > I am trying to get Excel to permanently change the cells in column B
> > to say "Tuesday" instead of 4/19/07.
>
> > Does that make sense? All of the conventional answers don't seem to
> > work for me. Any help?