2
I have data that I want to import into Excel. They’re phone numbers from multiple countries. For example:
David France 0145535663
Luis Spain 62333331
Mike USA 5465555112
The numbers have different lengths, so I can’t configure a special format in Excel :( and I need to keep the "0" in front of the numbers of some country.
Do you know an easy way to do that in Excel 2010?
The OP has a *column* of numbers, not just a single one. The question says, "The numbers have different lengths, so I can’t configure a special format in Excel." Your answer would require the user to manually set a custom format on each cell in the column. That's not practical. – G-Man Says 'Reinstate Monica' – 2017-01-16T06:26:13.267