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:
Actual Export due to Excel visibility:
|Resolution||FIX Truncation: Option 1
FIX Truncation: Option 2
44.02072451 converted to 440207245137 (truncation fixed)