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