thank u ron but david got the nail on the head, still appreciate your comment


"Ron Rosenfeld" wrote:

On Mon, 13 Aug 2007 05:32:02 -0700, yodochi
wrote:

hi, how do i split dollars and cent in 2 colums and at the end sum it,
for example: A1 Dollar, B1 cents, A2 dollar, B2 cents and in A3 and B3
the sum result of A1,A2 and B1 B2.
thanks for help


=SUM(B1:B2)/100+SUM(A1:A2)


--ron