Hi David,

The answer is 65. To clarfy more, These numbers are linked to diff
worksheet, so instead of going back to that link and see what is the absolute
number is, I was wondering if you can toggle back and forth the furmula and
see the absolute number or formula.

Thanks.
Dinesh

"David Biddulph" wrote:

"Dinesh" wrote in message
...
Hi,

I am looking for a formula which can convert formula into absolute number
not as a Total answer but adding the each number seperately.

Example
Col A
10
25
30

Formula is =a1+a2+a3..So the answer would be 45.

Did you mean 65, not 45? (or did you intend the 10 to be -10, which might
explain the reference to absolute, and makes the question different)?

... But I like to see the
answer as=10+25+30 or conver the formula into abolute number by addition
of
each number rather than total.

Is there a way to conver this?
--
David Biddulph