P3: 987 + 456 = 333

P4: 9557 + 1576 = 0023

(use custon formatting to show leading zeroes)

Begin by splitting the old numbers ... sum by column, mod sums by 10, then place the new numbers.

* | D | E | F | G | H |

2 | |||||

3 | 987 | = INT(D3/100) | = INT(MOD(D3,100)/10) | = MOD(D3,10) | |

4 | 456 | = INT(D4/100) | = INT(MOD(D4,100)/10) | = MOD(D4,10) | |

5 | =E5*100+F5*10+G5 | =MOD(E3+E4,10) | =MOD(F3+F4,10) | =MOD(G3+G4,10) | |

6 | |||||

7 | |||||

8 | 9557 | = INT(D8/1000) | = INT(MOD(D8,1000)/100) | = INT(MOD(D8,100)/10) | = MOD(D8,10) |

9 | 1576 | = INT(D9/1000) | = INT(MOD(D9,1000)/100) | = INT(MOD(D9,100)/10) | = MOD(D9,10) |

10 | =E10*1000+F10*100+G10*10+H10 | =MOD(E8+E9,10) | =MOD(F8+F9,10) | =MOD(G8+G9,10) | =MOD(H8+H9,10) |

Visually **=E10&F10&G10&H10** gives the same result as **=E10*1000+F10*100+G10*10+H10**.

The difference is the first is a text string, the second is still a number. You....

[ More ]

]]>