Csv files

Hi Matt,

Your problem looks like it's due to the file being saved as a csv as saving in this format won't preserve any formatting applied. So I would suggest you save it as an Excel Workbook instead.

If the leading zeros have 'dropped off', what you could do is format your cells or column containing the mobile numbers to restore the zeros by doing the following:

1. Select data and press Ctrl 1
2. Select 'Custom' at the bottom of the category list
3. In the 'Type' field type 00000000000 (ie. 11 zeros)
4. Click OK

This will work for mobile numbers with 10 digits missing the leading zero. Once you've done this you should be able to upload it to your phone directory as an Excel file where the formatting is preserved