Welcome to Excel Jet Consult blog post. In this short tutorial, we want to learn how to solve one of the most commonly experienced problem peculiar to Nigeria excel users. On several occasions, many professionals and excel users have called me to help them figure out how they can compel excel to accept the leading zero (0) when entering mobile number in the spreadsheet.
To answer this question broadly, we will apply the leading zero to the mobile number in column B of the caption below.
- To apply the leading zero, press CTRL + 1
- In the Format Cells dialogue box, select Custom
- Clear the General below Type
- Type in eleven zeros (the exact number of Nigeria mobile number). The sample of the result is visible
- Click OK. Task completed
Thank you so much. I tried this technique and it worked. I’ve been looking for how to solve this problem for two weeks now so that i can send bulk messages from excel directly. Thanks a lot