Newbie: Cell showing formula in words only. Help

Excel 97 on a XP Pro.

The formula for this cell is "=CASH!A1". I want it to just copy the
content of the A1 cell in the CASH sheet, so whenver I change the
content of A1 the cell will be updated automatically.

It used to work quite well until yesterday when it just show the words
"=CASH!A1" instead of getting the information.

What did I do wrong? Help

ABC

Gord
Sun May 27 20:42:02 CDT 2007

Does this occur with all formulas?

Perhaps you are in Formula View. Hit CTRL + `(backquote above Tab key)

OR

The cell was pre-formatted as Text.

Format to General then hit F2 then ENTER to re-enter the formula.


Gord Dibben MS Excel MVP


On Mon, 28 May 2007 09:23:23 +0800, ABC <ABC@nospam.net> wrote:

>
>Excel 97 on a XP Pro.
>
>The formula for this cell is "=CASH!A1". I want it to just copy the
>content of the A1 cell in the CASH sheet, so whenver I change the
>content of A1 the cell will be updated automatically.
>
>It used to work quite well until yesterday when it just show the words
>"=CASH!A1" instead of getting the information.
>
>What did I do wrong? Help
>
>ABC
>

ABC
Mon May 28 00:58:58 CDT 2007


Thanks. 2nd method worked.

What is the F2 and "enter" about? Where can I find this in the online
help?


I also tried to re-format the entire row of cells to GENERAL then F2
them. But I can only do the cells one by one. Any help appreciated.

ABC

On Sun, 27 May 2007 18:42:02 -0700, Gord Dibben <gorddibbATshawDOTca>
wrotd:

>The cell was pre-formatted as Text.
>
>Format to General then hit F2 then ENTER to re-enter the formula.
>
>
>Gord Dibben MS Excel MVP

Bob
Mon May 28 03:46:01 CDT 2007


"ABC" <ABC@nospam.net> wrote in message
news:dmrk535ksi2kjhcte2o942lft3cl2a1r2r@4ax.com...
>
> Thanks. 2nd method worked.
>
> What is the F2 and "enter" about? Where can I find this in the online
> help?

F2 is a quick way to put a cell into edit-mode. If you F2 and the just hit
Enter without changing anything, Excel will re-evaluate the cell and this
can be used to 'correct' some formats.

> I also tried to re-format the entire row of cells to GENERAL then F2
> them. But I can only do the cells one by one. Any help appreciated.

You could try selecting the column and then do a Data>Text To Columns and
hit the Finish button immediately.