Store mobile numbers in Excel

When storing mobile numbers in excel you will often find that unless you put a ‘ in front of the mobile number (Storing it as text) Then the 0 at the start of the number will disappear.

Heres my solution

1 reply
  1. Mario
    Mario says:

    The better option is to format cell as a text. If you try to use this number with advanced excel functions(e.g. concatenate) these zeros will disappear (this is not a value of the cell, it’s only formatting). Hope it helps.


Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

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