When you try to enter a phone number in to Excel you will find that Excel removes the Zero from the start of the number. This is because a number cannot start with a zero unless it is decimal. To solve this issue type an apostrophe in front of the number. Eg '01234567 instead of 01234567 and this will mean the zero is kept after you press enter.
