Changing a formula's result to text

  • Thread starter Thread starter Hoek
  • Start date Start date
H

Hoek

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)
 
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!
 
Back
Top