how do i write a formula and keep in in formula form, so it DOESN.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Writing a SUM Formula 5
Average Formula 1
how would I write a formula 7
Entering an "IF" formula 8
How do I write this formula 1
I need to write the formula for multiplying C3 and D3 1
Formula text in woorksheet cell 2
Dependent "If" formulas 2

Back
Top