Help/FAQs:Fix missing leading zeros in excel worksheet
Choose an option from the left hand menu.
  • Send a job to a pre-uploaded list, or to recipients from the one of the WEL Media or Business lists.
  • Send a one off job to a few manually specified recipients.
  • Upload and edit custom recipient lists or manage your list of opted out recipients.
  • View, cancel or retry existing jobs.
  • View reports on previous jobs.
  • Update your personal details or view current or old invoices/accounts.
"Click" below to find more about...

About Us

WEL Corporation

WEL Account Application

WEL Corp Privacy Policy

Opt-Out Statement Policy

Setup Jobs


WEL Wizard

WEL SMS Wizard

WEL Text-To-Speech Wizard

API Information

API Brochure

Manage Jobs

Job Reports

Your Broadcast History

Resend-Busy Numbers

Job Name

Job Number

Scheduling Jobs

Cancel Job

Broadcast lists

WEL Media

WEL Business Lists Online

WEL Broadcast Messaging

Your details

Change Registration Details

Change Your Password

Monthly Invoice

Fax Messages

Acceptable Page Formats

Test Your Message

Broadcast Error Codes

SMS messages


Test to speech messages

Preparation of WAV file for voice broadcast

Why use Text to speech

Tips for Voice messaging (TTS)

Text to Speech and
IVR Messaging Solutions

Faq's and troubleshooting


Fix missing leading zeros in excel worksheet

Adding leading zero to mobile/landline numbers in an excel spread sheet.

If your spread sheet is missing the leading zero in the number, here is a quick way to fix it:

  1. Make the column (for example column B) that contains the numbers without the leading zero to be "text" or "general" format.
  2. Go to a cell at in the same row as the first number in the list but in an adjacent column (for example cell C2).
  3. In cell C2, enter this formula: =Concatenate(0,B2)
  4. Copy that formula down column C for the entire length of the list of number.

Column C should now contain the entire list with the leading zero added on at the beginning.

Remember: Do this step in the Excel workbook before you convert the file to CSV.