Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: using the "values" command

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone help! This one is driving me nuts! I am trying to transform cells with formulas into cells with "real" numbers. I am using "edit, paste special, values" to do it. The problem is, when the numbers are transformed, they become fractions and alter the sums on my spreadsheet. Is there a way around this? Any tips would be great! THANKS!

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 16:06, giraffe wrote:
    Can anyone help! This one is driving me nuts! I am trying to transform cells with formulas into cells with "real" numbers. I am using "edit, paste special, values" to do it. The problem is, when the numbers are transformed, they become fractions and alter the sums on my spreadsheet. Is there a way around this? Any tips would be great! THANKS!
    Are your cells formatted as fractions? Also, how does this alter the sums? If Excel is recognizing the number as a fraction, it is still a number. Therefore, it can be summed. Can you post an example?

    Regards,

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-12 18:52, Barrie Davidson wrote:
    On 2002-03-12 16:06, giraffe wrote:
    Can anyone help! This one is driving me nuts! I am trying to transform cells with formulas into cells with "real" numbers. I am using "edit, paste special, values" to do it. The problem is, when the numbers are transformed, they become fractions and alter the sums on my spreadsheet. Is there a way around this? Any tips would be great! THANKS!
    Are your cells formatted as fractions? Also, how does this alter the sums? If Excel is recognizing the number as a fraction, it is still a number. Therefore, it can be summed. Can you post an example?

    Regards,

    Barrie,
    Thanks so much for even entertaining this problem! It is really difficult to explain without being able to show you but here goes. It is not that Excel is not "summing" the numbers. When I transform a number that is a sum into a real number it alters the sum because the number changes. Here is an example:
    0.67% * 9.57% = 0.06% when I do a "copy, edit, paste special, values" 0.06% becomes 0.064119% which ultimately changes the sum total of my spreadsheet. I need to find out if it is at all possible to have 0.06% remain 0.06% and not become 0.064119%. Do you know if this is possible, and if so, how? I hope I am being clear!
    Thanks again, giraffe

  4. #4
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,653
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-03-13 14:51, giraffe wrote:
    On 2002-03-12 18:52, Barrie Davidson wrote:
    On 2002-03-12 16:06, giraffe wrote:
    Can anyone help! This one is driving me nuts! I am trying to transform cells with formulas into cells with "real" numbers. I am using "edit, paste special, values" to do it. The problem is, when the numbers are transformed, they become fractions and alter the sums on my spreadsheet. Is there a way around this? Any tips would be great! THANKS!
    Are your cells formatted as fractions? Also, how does this alter the sums? If Excel is recognizing the number as a fraction, it is still a number. Therefore, it can be summed. Can you post an example?

    Regards,

    Barrie,
    Thanks so much for even entertaining this problem! It is really difficult to explain without being able to show you but here goes. It is not that Excel is not "summing" the numbers. When I transform a number that is a sum into a real number it alters the sum because the number changes. Here is an example:
    0.67% * 9.57% = 0.06% when I do a "copy, edit, paste special, values" 0.06% becomes 0.064119% which ultimately changes the sum total of my spreadsheet. I need to find out if it is at all possible to have 0.06% remain 0.06% and not become 0.064119%. Do you know if this is possible, and if so, how? I hope I am being clear!
    Thanks again, giraffe
    Did you consider activating "Precision As Displayed" before Edit|Paste Special >Values?

  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Barrie,
    Thanks so much for even entertaining this problem! It is really difficult to explain without being able to show you but here goes. It is not that Excel is not "summing" the numbers. When I transform a number that is a sum into a real number it alters the sum because the number changes. Here is an example:
    0.67% * 9.57% = 0.06%
    when I do a "copy, edit, paste special, values" 0.06% becomes 0.064119% which ultimately changes the sum total of my spreadsheet. I need to find out if it is at all possible to have 0.06% remain 0.06% and not become 0.064119%. Do you know if this is possible, and if so, how? I hope I am being clear!
    Thanks again, giraffe

  6. #6
    Guest

    Default

    Thank you so much Aladin! Your suggestion worked. My entire office thanks you!
    On 2002-03-13 14:53, Aladin Akyurek wrote:
    On 2002-03-13 14:51, giraffe wrote:
    On 2002-03-12 18:52, Barrie Davidson wrote:
    On 2002-03-12 16:06, giraffe wrote:
    Can anyone help! This one is driving me nuts! I am trying to transform cells with formulas into cells with "real" numbers. I am using "edit, paste special, values" to do it. The problem is, when the numbers are transformed, they become fractions and alter the sums on my spreadsheet. Is there a way around this? Any tips would be great! THANKS!
    Are your cells formatted as fractions? Also, how does this alter the sums? If Excel is recognizing the number as a fraction, it is still a number. Therefore, it can be summed. Can you post an example?

    Regards,

    Barrie,
    Thanks so much for even entertaining this problem! It is really difficult to explain without being able to show you but here goes. It is not that Excel is not "summing" the numbers. When I transform a number that is a sum into a real number it alters the sum because the number changes. Here is an example:
    0.67% * 9.57% = 0.06% when I do a "copy, edit, paste special, values" 0.06% becomes 0.064119% which ultimately changes the sum total of my spreadsheet. I need to find out if it is at all possible to have 0.06% remain 0.06% and not become 0.064119%. Do you know if this is possible, and if so, how? I hope I am being clear!
    Thanks again, giraffe
    Did you consider activating "Precision As Displayed" before Edit|Paste Special >Values?

  7. #7
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Aladin, your suggestion was exactly what I needed. Thanks so much. My entire office thanks you!

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
  •