Referencing a cell that has a custom format

  • Thread starter Thread starter brian.baker13
  • Start date Start date
B

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
 
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)
 
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
Click to expand...
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
Click to expand...
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.
Click to expand...
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?
Click to expand...
Much Appreciated
Click to expand...
Brian- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Spot on

Cheers Bob
 
Back
Top