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?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!
Regards,
Like this thread? Share it with others