using the "values" command

**giraffe** · Mar 12th, 2002, 04:06 PM

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!

**Barrie Davidson** · Mar 12th, 2002, 06:52 PM

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,

**giraffe** · Mar 13th, 2002, 02:51 PM

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

**Aladin Akyurek** · Mar 13th, 2002, 02:53 PM

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?

**giraffe** · Mar 13th, 2002, 02:58 PM

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

Mar 14th, 2002, 09:50 AM

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?