Cell Values from other worksheets

[Bowlnhokie]

If i reference cells from another worksheet but no longer want the formula referenced in the new worksheet, i just want to numbers, how can i do this.

thanx
Nick

 

[Jack in the UK]

Try

=TEXT(Sheet2!A2,0)

amend as needed

 

[Bowlnhokie]

Just to make sure:

If i refer to another sheet and that cell has a formula giving me an answer of 100. when i paste it to another worksheet and just want to click on the cell have the number 100 in it with no formula, this should work.

sorry i am a little slow today

 

[Mark W.]

On 2002-04-24 14:50, Bowlnhokie wrote:
If i reference cells from another worksheet but no longer want the formula referenced in the new worksheet, i just want to numbers, how can i do this.

thanx
Nick

Copy then Edit | Paste Special... Values will overlay these formulas with their resultant values.<font color=red>See the Excel Help Index topic for "Replace a formula with its calculated value".</font>
This message was edited by Mark W. on 2002-04-24 15:13

 

[excelmacro]

You could also edit the cell properties and select to hide the formulas and then protect the sheet. That way the cell would always update, you just couldn't tell that there is a formula there.

 

[Bowlnhokie]

Thank you to everyone, i am sure i will back soon