| Paul, you need to include text in your formula and copy that formula to all of your cells.
e.g. in cell C8 I have entered 7425
I have formatted cell C8 to 6 0's (custom format)
in cell C9 I have entered a number 12 (no custom formatting)
in cell C10 I would normally have entered =C8*C9 and seen a result of 89100
Custom formatting cell C10 could produce 089100 with your leading zero's, but you could also use the following formula instead:
=TEXT(C9*C8,"000000")
Unfortunately that does turn the cell into text but you can still use that text in another formula e.g. =C10*1 = 89100
Merging into Word you will need to alter the field formatting withinthe word document - use F9 to reveal field codes |