Cell Values from other worksheets

Bowlnhokie · Apr 24th, 2002, 03:50 PM

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 · Apr 24th, 2002, 03:53 PM

Try

=TEXT(Sheet2!A2,0)

amend as needed

Bowlnhokie · Apr 24th, 2002, 03:59 PM

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. · Apr 24th, 2002, 04:00 PM

Quote:

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. See the Excel Help Index topic for "Replace a formula with its calculated value".

[ This Message was edited by: Mark W. on 2002-04-24 15:13 ]

excelmacro · Apr 24th, 2002, 04:04 PM

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 · Apr 24th, 2002, 04:08 PM

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

Apr 24th, 2002, 03:53 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Try =TEXT(Sheet2!A2,0) amend as needed __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 03:50 PM	#1
Bowlnhokie Board Regular Join Date: Apr 2002 Posts: 192	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

Apr 24th, 2002, 03:59 PM	#3
Bowlnhokie Board Regular Join Date: Apr 2002 Posts: 192	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

Apr 24th, 2002, 04:04 PM	#5
excelmacro Board Regular Join Date: Apr 2002 Location: Alberta, Canada Posts: 50	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.

Apr 24th, 2002, 04:08 PM	#6
Bowlnhokie Board Regular Join Date: Apr 2002 Posts: 192	Thank you to everyone, i am sure i will back soon