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.

Text format example

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.