Excel help

Occasional Contributor

Hello all, i have attached images at the bottom for easier understanding of my problem.


Under this image, for V7, i am trying to write a formula to get the value from the other workbook named "Inputs by AL" at L7. (see next image) The problem is that, i am unable to do so. Can anyone tell me if i am doing the formula wrongly or anything. Thank you





2 Replies
best response confirmed by alphadrag (Occasional Contributor)


The number format of V7 is set to Text. This causes the cell to display the formula.

Change the number format to General.

Then press F2 to edit the formula and press Enter without changing anything. The cell should then display the result

Thank you. It worked