Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Formula to Value

    I have to convert formula's to actual values, I do this by pressing F2 then F9, unfortunatley I can only do one cell at a time. ( or does someone know different),

    I am using Excel Office 97 SR2b
    If you are a fool at forty, you will always be a fool

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Michigan, USA
    Posts
    26
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Value

    have you tried to Copy then Edit>Paste Special>Values?

    Mark

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Value

    Select all of the cells that you want to convert, and the select Copy from the Edit menu. With the same cells still selected, select "Paste Special" from the Edit menu. In the dialog box, click on "Values" in the "Paste" section, then click on OK. All of the cells should be converted to values.
    Legare Coleman

  4. #4
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Formula to Value

    You might want to put the "Paste Values" Icon on your toolbar. I use it a lot.
    -John ... I float in liquid gardens
    UTC -7ąDS

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula to Value

    Thanks to all who replied, It works fine
    Braddy60
    If you are a fool at forty, you will always be a fool

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula to Value

    I do this so often I have a macro on a button to do Copy & Paste Special/ValuesOnly in one hit:

    Sub ReplaceWithValues()
    Selection.Copy
    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
    SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = True
    End Sub

Posting Permissions

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