Displaying Formula Result Error

  • Thread starter Thread starter Shane
  • Start date Start date
S

Shane

When typing a formula, I cannot see the result.

I have tried ctrl + ~, however this just expands all columns. Thi
only seems to happen on some of my worksheets.

Any suggestions are grealtly appreciate. I have also tried searchin
for an similar question, but could not find one.

Thanks!!!

Shan
 
Shane

Maybe the cells were formatted as text when you typed the formula?

Andy.
 
Shane

What do you see if not the result? The formula?

Possible that the cell was pre-formatted as Text.

Format to General and re-type the formula or hit F2<ENTER>

If you have a bunch of these, select the cells then Edit>Replace

What: =
With: =

Replace all.

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

Excel VBA 1
Excel Formula displays text of formula 2
Need to display values instead of formula; Ctrl + ` doesn't work 1
Displaying BOTH formulas and values 6
Countif result problem 4
cells show formula like in formula bar, rather than result of form 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Dispaly results, rather than a formula 2

Back
Top