The easiest is to pick the column column (A), do Data-Text to Columns click
next in the next screen select other and put a . in the box and hit finish.
Column b must be empty before you do this. The just autosum at the bottom.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"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