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 201...
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