Changing a formula's result to text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hoek - 09 May 2008 17:49 GMT

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?

Reply to this Message

Ron Coderre - 09 May 2008 18:04 GMT

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)

> I have a pretty simple worksheet that lists the date in column A.
>
[quoted text clipped - 12 lines]
> Does that make sense? All of the conventional answers don't seem to
> work for me. Any help?

Reply to this Message

Hoek - 09 May 2008 19:44 GMT

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.
>
[quoted text clipped - 27 lines]
> > Does that make sense? All of the conventional answers don't seem to
> > work for me. Any help?

Reply to this Message