linked cell that wont display properly

Occasional Visitor

I have a linked cell that won't display properly. I am attempting to link cells from two different worksheets together, but the cell will not display properly. The cell only displays "0" but the number in the cell it is linked to is "103,000". I have checked the formatting of the cells, and everything is correct. However, even though the cell displays "0", the sum function that it is included in is clearly picking up the 103,000. How can I fix the display? 


1 Reply


Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?