Thanks:  0
Likes:  0

# Thread: using the "values" command

1. 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. 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,

3. 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. 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. 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. 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. Aladin, your suggestion was exactly what I needed. Thanks so much. My entire office thanks you!

## User Tag List

#### Posting Permissions

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