Results 1 to 4 of 4

Thread: Numbers (2003)

  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Numbers (2003)

    I have a column with formulas that give me the answers in currency and I want to somehow change the answers to real number and no formula. For example: =SUM(A1*A2) and the results is $34.56, I want to change the $34.56 to the number $34.56 and no formula.

  2. #2
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers (2003)

    The simple way is to copy the cell then paste special > select "Values" from the option list. Do you have to do a lot of these?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

  3. #3
    3 Star Lounger
    Join Date
    Mar 2003
    Location
    Beddau, Mid Glamorgan, Wales
    Posts
    289
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Numbers (2003)

    Alternatively, go to the cell with the formula, press F2, F9, ENTER.

    The F2 function key puts the cell into edit mode and F9 recalculates the formula to its value.

    Tony.
    Regards,

    Tony
    [s] [/s]
    www.SylviArtist.com

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Numbers (2003)

    To apply Bilas's method to multiple cells, choose EDIT | GO TO and select the SPECIAL button. Choose Formulas and OK. This selects all the formulas on the sheet. Then press F2, F9, and CONTROL + ENTER.
    ALL formulas are now changed to values.
    Regards,
    Rudi

Posting Permissions

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