Excel 07 cell reference formula only showing literal text not value

G

GiJeet

Hi, I've used Excel before but not 2007 version. I have a simple cell
reference formula in a cell B2 that I'm trying to reference the value
in A2. In B2 I have =A2. And all that is displaying in B2 is the
literal text of the formula, it is not returning the value in A2.
I've never experience this behavior in Excel. With a simple cell
reference formula it should return the value it's trying to reference
not the literal text. Is there something new in 2007 I need to do?

TIA
G
 

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

Cumulative formula for word table 0
Excel ignore formula 8
Matching literal text "???" in Word 2010 field code IF statement 2
Cross reference drop down not activating 1
Excel 2003 with Reference error cause me a headache 0
Word macro that can call cells out of Excel for a find and replace 0
countifs Function not giving desired result with date criteria 2
External cell reference between two excel worksheets both in One Drive 0

Top