Overview:

The Network Subscription Process in CRM is returning Addresses with IDs formatted with zeros at the end, such as: 852352217691194000. Why is this happening?

Answer:

A Comma Separated Values (.CSV) file is imported or edited in Microsoft Excel. It is a known feature in Excel that when importing .CSVs, the last 3 digits of the IDs transform to the closer thousand.  This results in the occurrence described above. 

Use an editor designed specifically for working with .CSV files.  Example: Ron's Editor.

Related Documentation:

N/A

Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.

Thank you