Phone numbers in Excel

One of the common uses for Excel is to keep a list of contacts; names, addresses and telephone numbers. But, the problem is that when you enter the ‘phone number you lose the leading 0. so a ‘phone number of 01234567899 becomes 1234567899. It is also aligned to the right instead of the left.

To stop losing the 0 in front of the ‘phone number and get it to line up with the rest of the text you put in all you have to do is type an apostrophe before you enter the number. In the above example this would be: ’01234567899

The apostrophe tells Excel to treat the number you are entering as text and not a numerical value.

Comments are closed.