Select the search type
  • Site
  • Web
Search

Part numbers changed during export to Excel.

Q: When I export part numbers from Complete Contact CRM it changes some of the numbers to dates like 03-09-2011 to 03/09/2011 or when there is a large number it shows up like with an E (e.g. 210005.E ).

A: That is a Microsoft Excel problem. Excel "intelligently" decides that the value is a date or a large part number is a number instead of text and formats the cells accordingly to date or to be expressed on engineering notation. You can confirm this by opening the exported file in notepad BEFORE you open the file in Excel. After you open the file in Excel and save it, the file will contain the changes incorrectly made by Excel.