Let's start over. I assumed your sheet would look something like this:
A1: 1+50.23
B1: 2+36.46
C1: [the formula doing the addition]
At any rate, conversion back might work with:
=INT(A1/100)&"+"&MOD(A1,100)
It won't work if the number after the plus sign ever exceeds 100.
|