Inserting values that start with 0
To enter numbers that starts with a zero eg mobile telephone numbers, start with the single inverted comma ‘ then type the number and press Enter.
If you are going to enter a whole column of them, it may be easier to format the whole column as Text – see image below.
When you use the Text format you don’t need to use the inverted comma, just type the number.
Please note: I reserve the right to delete comments that are offensive or off-topic.