Forum Discussion
Tanya Hemmer
May 29, 2018Copper Contributor
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.
1 Reply
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