how do I get a cell in excel to show the formula and not the word

G

Guest

I have a problem with excel. When I enter a formula into a cell and hit enter
I get the word "Value" in the cell and not the answer to the formula. I know
I am missing something because it's only my excel at work that does this the
one I use at home shows me the answer and not the word. Someone tell me what
I am missing. Is it in my options setup or in the worksheet itself? Any help
will do. Tks
 
D

Dave Peterson

You can get #value! errors when your formula tries to do arithmetic using cells
that contain non-numeric data.

If you have 1234 in A1 and Bertie in A2, if you type:
=a1+a2
You'll get the error.
1234+Bertie doesn't make sense to excel.
 

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

How to reference the formula in a cell. 3
Excel 2007 Not returning formula result 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
how do i show the calculated value in a cell rather than formula 3
Dragging a formula across the row in 2007 2
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
one cell in my worksheet appears blank, but answr shows in formula 6
Function to determine if a cell contains a formula 5

Top