Forum Discussion
Solved
Excel Formula Problem
I have a worksheet called 'Pay Details' which I am referencing from another worksheet in the same Workbook. I entered ='Pay Details'!A3 in a cell in the other sheet but instead of the data from th...
Did you confirm that the cell is not formatted as text? Right click, select "number format" from the menu, and I think it should bring up a dialog box. If it's text, change it. Then click in formula bar and hit enter to re-enter the formula.
Check the cell format to see if it is text. If so, change it. Then click in the formula bar to go into edit mode and hit enter.
Or, it could be that show formulas is turned on. Check the show formulas toggle button under the formulas tab.
Or, it could be that show formulas is turned on. Check the show formulas toggle button under the formulas tab.
JMB17 Thanks for replying. I only have the online Excel so I don't have the choices under 'Formulas'
Did you confirm that the cell is not formatted as text? Right click, select "number format" from the menu, and I think it should bring up a dialog box. If it's text, change it. Then click in formula bar and hit enter to re-enter the formula.
JMB17 Ignore my previous reply - i have followed your advice in full with SUCCESS!
Many thanks
