Link cell

[Laura]

How I can link one cell from one sheet to other sheet.
The result that I am geting is only ='01 PSW'!A6:F6 and
not real value like "pole piece"

 

[_Bigred]

try

=(01 PSW!A6:F6)

You need it in the paranthesis.

Let me know,
_Bigred

 

[Ken Wright]

You don't need any parentheses. It sounds more like one of the following scenarios:-

1) The cell was formatted as text prior to entering the formula. Fix - Format the cell as
general and with that cell selected, hit F2 then hit Enter.

2) The spreadsheet is set to display formulas. Fix - Tools / Options / View Tab / Uncheck
'Formulas' in lower portion of dialog box.

 

[Laura]

Put in paranthesis do not work.

-----Original Message-----
try

=(01 PSW!A6:F6)

You need it in the paranthesis.

Let me know,
_Bigred






.