How can I insert a phone number like 07111111111 into a cell without the 0 disappering?! I need to make a contact database.
Help is appreciated!
asked Oct 18 '11 at 07:17
The easiest way is by simply typing a ' before the number. So, if you type '07111111111 it will simply appear as 07111111111. Or you can change the input type to 'Text' and it will simply display the number as text, and therefore won't get rid of the 0.
answered Oct 18 '11 at 07:28