Forum Discussion
WilsonsConvStore
Jul 29, 2020Copper Contributor
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...
- Jul 29, 2020
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.
NikolinoDE
Jul 29, 2020Platinum Contributor
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)
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)