I am running a football scores competition. I have a sheet which will contain all the results as they occur. As yet the competition has not started so all scores are blank.
But when I link the scores to another sheet it shows as 0-0 which looks like the match has been played and the score is 0-0.
i.e. results sheet shows "Team A Team B " but the cell that links to it shows "Team A 0 Team B 0"
I have seen a work round whereby you set the cell fromat to custom and then type in 0;-0;. This is allows the cell to show blank instead of 0, but there is a problem. The cell now cannot show 0 even when a 0 is typed in to the results sheet.