Leading 0's Format As Text Restricts Column Pasting

[Lewzerrrr]

Hey,

I have a data source of numbers from AS400 that I need to paste into Excel, I usually manually type the zero after the left cell but wanted to see if possible to paste in leading zero's which it was if you format as text. However this now pastes the whole data source into one column and not multiple?

See examples below.

[TABLE="width: 998"]
<colgroup><col span="4"><col span="6"><col><col span="3"></colgroup><tbody>[TR]
[TD="colspan: 4, align: center"]How I do it now, put the zeros at end of A and C.[/TD]
[TD][/TD]
[TD="colspan: 4, align: center"]How I'd like to paste in.[/TD]
[TD][/TD]
[TD="colspan: 4, align: center"]How it pastes in with text format.[/TD]
[/TR]
[TR]
[TD]Header1[/TD]
[TD]Header2[/TD]
[TD]Header3[/TD]
[TD]Header4[/TD]
[TD][/TD]
[TD]Header1[/TD]
[TD]Header2[/TD]
[TD]Header3[/TD]
[TD]Header4[/TD]
[TD][/TD]
[TD]Header1[/TD]
[TD]Header2[/TD]
[TD]Header3[/TD]
[TD]Header4[/TD]
[/TR]
[TR]
[TD="align: right"]30[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]84[/TD]
[TD][/TD]
[TD]3[/TD]
[TD]014[/TD]
[TD]2[/TD]
[TD]84[/TD]
[TD][/TD]
[TD]3 014 2 84[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]10[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]59[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]024[/TD]
[TD]43[/TD]
[TD]59[/TD]
[TD][/TD]
[TD]1 024 43 59[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]330[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]95[/TD]
[TD][/TD]
[TD]33[/TD]
[TD]042[/TD]
[TD]1[/TD]
[TD]0095[/TD]
[TD][/TD]
[TD]33 042 1 0095[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]16[/TD]
[TD="align: right"]85[/TD]
[TD="align: right"]93[/TD]
[TD="align: right"]43[/TD]
[TD][/TD]
[TD]16[/TD]
[TD]85[/TD]
[TD]93[/TD]
[TD]43[/TD]
[TD][/TD]
[TD]16 85 93 43[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]51[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]92[/TD]
[TD][/TD]
[TD]51[/TD]
[TD]17[/TD]
[TD]1[/TD]
[TD]092[/TD]
[TD][/TD]
[TD]51 17 1 092[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]860[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]5000[/TD]
[TD="align: right"]34[/TD]
[TD][/TD]
[TD]86[/TD]
[TD]062[/TD]
[TD]5[/TD]
[TD]00034[/TD]
[TD][/TD]
[TD]86 062 5 00034[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]43[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"]74[/TD]
[TD][/TD]
[TD]43[/TD]
[TD]60[/TD]
[TD]48[/TD]
[TD]74[/TD]
[TD][/TD]
[TD]43 60 48 74[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]41[/TD]
[TD][/TD]
[TD]6[/TD]
[TD]56[/TD]
[TD]9[/TD]
[TD]41[/TD]
[TD][/TD]
[TD]6 56 9 41[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]65[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]96[/TD]
[TD][/TD]
[TD]65[/TD]
[TD]74[/TD]
[TD]22[/TD]
[TD]96[/TD]
[TD][/TD]
[TD]65 74 22 96[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]