Referencing a cell that has a custom format

[brian.baker13]

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

 

[Bob Phillips]

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

--
---
HTH

Bob


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

 

[brian.baker13]

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

--
---
HTH

Bob

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

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- Hide quoted text -

- Show quoted text -

Spot on

Cheers Bob