Either pre-format the cell as Text or hit CTRL + `(back quote above TAB key)
to toggle "view formulas" on/off.


Gord Dibben Excel MVP

On Thu, 3 Feb 2005 19:41:01 -0800, norcalchick2207
wrote:

i have to take a computer test and one of the questions is to write a formula
i've previously used but write it so the actual formula is shown on the sheet
and when its printed so how do i do i write the formula because everytime i
do it it calculates but i need it to stay in formula form with the = sign too?