Excel Formula Problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1647810%22%20slang%3D%22en-US%22%3EExcel%20Formula%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647810%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EI%20have%20a%20worksheet%20called%20'Pay%20Details'%20which%20I%20am%20referencing%20from%20another%20worksheet%20in%20the%20same%20Workbook.%20I%20entered%20%3D'Pay%20Details'!A3%20in%20a%20cell%20in%20the%20other%20sheet%20but%20instead%20of%20the%20data%20from%20the%20target%20cell%20it%20shows%20%3CA%20href%3D%22https%3A%2F%2Fmrdigitalpiano.com%2Fdigital-piano-vs-keyboard%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3D%3C%2FA%3E'Pay%20Details'!A3%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1647810%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1647871%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%20Problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1647871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F786992%22%20target%3D%22_blank%22%3E%40ishuwan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%20this%20cell%20is%20in%20text%20format.%20If%20so%2C%20apply%20General%20and%20re-enter%20formula%20(F2%2C%20Enter).%20In%20addition%20please%20check%20on%20ribbon%20if%20Formulas-%26gt%3BShow%20Formulas%20is%20OFF%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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

1 Reply
Highlighted

@ishuwan 

Perhaps this cell is in text format. If so, apply General and re-enter formula (F2, Enter). In addition please check on ribbon if Formulas->Show Formulas is OFF