Cell shows formula not the result

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

Guest

Hi
I have an unusual problem. When I change the formula (in this instance a
VLOOKUP when I change the range) the cell shows the formula not the result,
(as if I had put a ' before the = or typed CTRL+`)

- It only effects cells I change in one column in my spreadsheet
- If I drag the original formula down I dont get this problem
- I do not think I have changed any settings

I am using Excel 2003 SP2 on Windows XP Pro SP2

Thanks in advance for any help
 
The cell was formatted to Text after the formula was applied.

For example put =1+2 in a cell - cell will show 3 - formula bar shows the
formula
Format the cell as Text - cell STILL shows 3 - formula bar STILL shows the
formula
Edit for formula, make the 2 into a 5 - now the cell shows only the formula
 
Thanks! - it works fine now


Gary''s Student said:
The cell was formatted to Text after the formula was applied.

For example put =1+2 in a cell - cell will show 3 - formula bar shows the
formula
Format the cell as Text - cell STILL shows 3 - formula bar STILL shows the
formula
Edit for formula, make the 2 into a 5 - now the cell shows only the formula
Click to expand...
 
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

Searching the formula (not the value) for a text string 1
Formula or function displays after edit and not its result 3
Counting Results of Formulas 1
formula displays as a formula, not as its result 1
Excel VBA 1
HELP!!!!!!!!! 2
Copying formulas across columns 2
Why does forumula show in cell instead of formula result? 2

Back
Top