leading zeros with both numbers and letters in string

[irrefutable14]

I need to add leading zeros before two separate strings for all in column E. For example:


[TABLE="width: 111"]
<colgroup><col width="111"></colgroup><tbody>[TR]
[TD="class: xl67, width: 111"]0336565-CM[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 111"]
<colgroup><col></colgroup><tbody>[TR]
[TD]336700[/TD]
[/TR]
</tbody>[/TABLE]

 

[FDibbins]

Is that what you have, or what you want?