How do I link a title to another sheet in Excel? It just shows the number '0' instead of the title?

When I link a title from the first sheet in Excel to a cell in the second sheet and then hit enter, instead of copying the title, it just gives the number "0". If I try to link something that is already a number, it links and copies just fine. What setting do I need to change so it will link the... show more When I link a title from the first sheet in Excel to a cell in the second sheet and then hit enter, instead of copying the title, it just gives the number "0". If I try to link something that is already a number, it links and copies just fine. What setting do I need to change so it will link the title/subject instead of translating to a zero?? I have Excel version 2003.
1 answer 1