Dollars in in B, cents in C, Data shown

Dollars Cents Cu Sum
7 56 7.56
3 44 11.00
2 24 13.24
45 23 58.47

C2: =SUM($B$2:B2)+SUM($C$2:C2)/100 and copy down

Regards
Peter A


"yodochi" wrote:

One column for the dollars and the other for the cents? If so, use the Text
to Columns, Use Delimited as the split option (Step 1) and select Other, type
in the decimal point in the blank to the right of the Other option in step 2.

This is good, but how do i keep it in the colums is i introduce new data and
how do i sum it up (the colums) to get a final number with decimals in there
corresponding colums?