Simple question ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wmd - 22 Jul 2006 19:59 GMT

I have an annoying problem with Excel that I can't solve for the life of me!

In my workbook, I currently have several sheets that have identical
formats. I use the formula "=Sheet1!A1" to copy text data from one sheet
to the next.

I currently have all ten sheets copying the text data from Sheet1. I
want to change each sheet to copy from the sheet before it... a simple
change (I thought). So, for example, in Sheet3 I ~currently~ have
"=Sheet1!A1", but I want to change it to "=Sheet2!A1", and so on.

When I make the change, however, the result doesn't appear but rather
the text of the formula. So in Sheet3, instead of copying the name from
Sheet2, it shows exactly "=Sheet2!A1".

I've fiddled with the settings in Options, with no luck. Does anyone
know what could be causing this, and what fix there is?

Thanks very much for any responses!

wmd

Reply to this Message

Ron Rosenfeld - 22 Jul 2006 20:28 GMT

>I have an annoying problem with Excel that I can't solve for the life of me!
>
[quoted text clipped - 17 lines]
>
>wmd

I assume the quote marks you show around the formula are not in the worksheet.
If so remove them.

If the cell is formatted as TEXT before you enter the formula, you will get the
results you describe. Before changing/entering the formula, format the cell as
General.
--ron

Reply to this Message

wmd - 22 Jul 2006 22:30 GMT

> I assume the quote marks you show around the formula are not in the worksheet.
> If so remove them.
[quoted text clipped - 3 lines]
> General.
> --ron

Thanks for your reply. You initial assumption was correct: there were no
quote marks in the formula.

Your solution re: changing the format to "General" worked. Since the
existing formula was working with the cell format already set to "Text",
I didn't realize that the cell had to be changed back to "General"
~before~ a new formula was entered into the same cell.

Thanks again!

wmd

Reply to this Message

Ron Rosenfeld - 23 Jul 2006 02:19 GMT

>> I assume the quote marks you show around the formula are not in the worksheet.
>> If so remove them.
[quoted text clipped - 15 lines]
>
>wmd

You're welcome. Glad to help.
--ron

Reply to this Message