Forum Discussion
Cell Reference errors
Trying to create a small table that references data from another table on the same worksheet by using the formula =A2. Certain cells are reading the formula instead of the cell data. Using Excel 2013. How do I correct this issue.
It sounds like some cells are formatted as text.
In the Home ribbon change the type from Text to General then double click in the cell and press enter
