Split text to columns loosing "0" in numbers

[soli004]

Dear forum!
I have tried several ways to split text to columns where the cells include text and telephone numbers. The problem is that all numbers starts with "0" zero and I loose this when splitting.
How do I split without loosing the zero values in the telephone numbers?

Sample file how the data can look like with the wanted result

Thanks

[Speshul]

Change the format to Text on the desired columns in the Text to Columns dialog (Step 3 of 3). It defaults to General, which will lose your leading Zero.

Alternately if it is the same number of digits (4 digits = 1234, 0123, 0003, 9999) you could change the format for that column to "0000"