Forum Discussion
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 the target cell it shows ='Pay Details'!A3 |
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.
17 Replies
There are few possible reasons,,
- The Show formula option is clicked.
- Check File, Option, Advance,, and in Display options for the Sheet, the "Show formula in cells instead of their results", is clicked.
Hi Rajesh_Sinha
Thanks, but this is not the case.
The two solutions you show are basically the same feature. a shortcut to this is ctrl + ` (the apostrophe, usually above the tab key on a US keyboard)
But that feature applies to all cells in the sheet. This issue is something which happens cell by cell.
IMHO, this is a bug in Excel. If a formula refers to a cell which is formatted as text, the cell with the formatting becomes text formatting as well. That's not a problem, but the next time you edit the cell, the formula shows and not the value.
Mainow ,, yes you are write,, in case of Formula only, if starts with Sheet reference like =Sheet1!A1, and if the cell is formatted as TEXT,, Excel returns the Formula instead of value, but if the cell has Numeric or Date value, then works properly.
Since the OP hasn't shared the Workbook to examine so that I've suggested two of common possibilities.
- 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.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.
- Anything could be possible, according to the info.
A pre-prepared template would be advantageous
... or rather what formula for which part of your project you would like
... however it could be an empty space for = or so...just Copy/Paste
= Pay Details'! A3
Nikolino
I know I don't know anything (Socrates)
