Linking - destination cell shows "0" instead of value in source ce

[lh1]

I'm trying to create a summary worksheet to show an overview of our
departments annual leave. Each member of the dept has a separate sheet to
record their leave on and we need another one to summarise.
However, when I try and create links from the individual (source) sheets to
the summary (destination) sheet, I get "0" displayed in the cell rather than
what's in the cell (should be displaying a date)
All cells in all sheets are formatted as general.

 

[Pete_UK]

Post the formula you are using.

Pete

 

[Shane Devenshire]

Hi,

There is apparently a problem with the formula you typed, don't type it.
Move to the cell on the summary sheet where you want the first result and
type = then click the sheet tab for the first employee and then click on the
cell with the value you want returned, then press Enter.

You will have a formula like
='Sheet 1'!A1

Repeat for each employee.

 

[lh1]

That's what I was doing - I didn't type the formula.

However, I managed to work out that the problem was that the cell I was
linking from was actually two merged cells. When I changed the cell reference
in the formula to the first of the merged cells, it worked fine.

Many thanks for your responses though!

 

[David Biddulph]

Now you see one of the *many* reasons why experts here keep recommending
that you avoid merged cells like the plague.