Help/FAQs:Fix missing leading zeros in excel worksheet
To start a new broadcast, choose a list to send to from Media Lists, WEL Lists or My Lists. You can send to, create and manage your personal lists by choosing an option under My Lists. If you have started a broadcast, but have not completed it, you can continue it by choosing 'Continue Existing' under Job Management. You can view the progress of any broadcast not yet complete by choosing 'View Progress' under Job Management. To view reports of complete broadcasts, or delete an incomplete broadcast, choose 'All Jobs' under Reports. To view a history of all complete broadcasts, choose 'Completed Jobs' under Reports. Manage your personal details and view your accounts under My Details. To manage your opt-out lists, go to 'Optout List' under My Lists
|
If your spread sheet is missing the leading zero in the number, here is a quick way to fix it:
- Make the column (for example column B) that contains the numbers without the leading zero to be "text" or "general" format.
- 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).
- In cell C2, enter this formula: =Concatenate(0,B2)
- 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.
|
|