Print this page

Data.com: UK Phone Numbers Truncated When Exporting to CSV from Data.com Tab

Knowledge Article Number 000149026
Description When exporting UK phone numbers to CSV from Data.com, phone numbers will in some cases be truncated.  The data is not missing, it's simply case of how Excel handles numbers formatted for international use.

Example: Expected export value:
44.0207245137

Actual Export due to Excel visibility:
44.02072451
Resolution FIX Truncation: Option 1
  1. Open CSV containing UK phone numbers
  2. Select the phone number column
  3. Right-click on column and select 'Format Cells'
  4. Select 'number' and click OK
  5. Move decimal place out to ten places
  6. Click OK
  7. Now save file as an as a .csv file
*This should retain the full length of the phone number within the CSV

FIX Truncation: Option 2
  1. Open CSV containing UK phone numbers
  2. Select the phone number column
  3. Right-click on column and select 'Format Cells'
  4. Select TEXT and click OK
  5. Press CTRL and F on keyboard, bring up the 'find' option; click on the replace tab
  6. Search for '44.'
  7. Replace with '44'
Expected Result:
44.02072451 converted to 440207245137 (truncation fixed)




promote demote