Referencing a cell that has a custom format

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

brian.baker13@googlemail.com - 07 Jan 2008 12:12 GMT

Hi

I am trying to reference a cell in another sheet by clicking on the
cell
='[Labour Variance Report wk01.xls]Summary'!$BA$44:$BC$44
The cell is actually BB44 but is spread across 3 columns and when i
click on the cell i get $BA$44:$BC$44

The cell BB44 (166) is set as a custom type #,##0;(#,##0) to record an
accounting type display to show adverse numbers i.e. those in
brackets.

When I reference this cell I get a #value! error when all i want is to
pull across the 166 figure as a number. How could I do this please?

Much Appreciated

Brian

Reply to this Message

Bob Phillips - 07 Jan 2008 12:42 GMT

I think you have merged cells, and that although it looks like BB44 the data
is actually in BA44

Try

='[Labour Variance Report wk01.xls]Summary'!$BA$44

Signature

---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Hi
>
[quoted text clipped - 14 lines]
>
> Brian

Reply to this Message

brian.baker13@googlemail.com - 07 Jan 2008 21:00 GMT

> I think you have merged cells, and that although it looks like BB44 the data
> is actually in BA44
[quoted text clipped - 35 lines]
>
> - Show quoted text -

Spot on

Cheers Bob

Reply to this Message