Views:

How to fix phone number if missing a zero at the front of the number on club import file

These instructions are to help Clubs who have club import files which excel are dropping the zero at the front of their club import file.

  1. Open excel and the file which is missing the zeros from the phone numbers
  2. Highlight the column with the phone numbers
  3. Click on Data> Text to Columns
  4. A pop-up window will appear.  Select OK.  This will convert all numbers to a general format.
  5. Highlight the column with the phone numbers
  6. Right click the column and choose the option 'Format Cells'.
  7. Go to the 'Custom' option from the left.
  8. In the 'Type' text box type in 10 zeros in this format 0000 000 000.
  9. Save the file as text
  10. Open a new excel file
  11. Go to Data>Get Data from Text/CSV
  12. Import text file into excel.
  13. Copy all the text including the headers.
  14. Open a new excel spreadsheet.
  15. Right hand click in cell A1
  16. Select Paste Values 
  17. Highlight the birthdates column
  18. Right click the column and choose the option 'Format Cells'.
  19. Go to the ‘Date’ option from the left.
  20. Select the format DD/MM/YYYY and select OK.
  21. Save file as a CSV (Comma Delimitered) (*.csv) file

If you require any further assistance, please contact us.