1. You are in "formula view". Hit CTRL + `(above Tab key)

2. The cell was pre-formatted as Text. Format to General then F2 and ENTER


Gord Dibben MS Excel MVP

On Sun, 22 Jun 2008 11:57:00 -0700, des-sa
wrote:

when i type in a formula, say =QUOTES!A18, it is displayed as =QUOTES!A18
instead of the value of cell A18 in the sheet named QUOTES. what am i doing
wrong?