Part numbers changed during export to Excel
Solution ID:4 Type: Solution Updated On: Jan 30, 2020 05:01 PM
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.
Jan 30, 2020 03:17 PM
Jan 30, 2020 05:01 PM
Solution marked as Expired
Mark as Expired