Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Cell Values from other worksheets

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    196
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    196
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Location
    Alberta, Canada
    Posts
    50
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  6. #6
    Board Regular
    Join Date
    Apr 2002
    Posts
    196
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •