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

Excel ignore formula 8
Returning one of two values in Microsoft Excel 2003 1
dragging formulas acros adjacent cells 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Referenced cell displays formula, not data 4
Copied formula produces unexpected copied results 1
countifs Function not giving desired result with date criteria 2
Excel conditional formatting with Weeknum 4

Top