When I export a BoM in Enterprise PDM some of our part numbers are imported into excel in a date format.
Does anyone know how to export the file to that the part number column is formatted in "Text" format?
When using the Text Import Wizard in Excel, you need to set the specified column as Text, not General.
so this means that i actually need to save the csv file then open it from within Excel?
I was hoping that there would be a master option to allow me to open the csv directly from the bom menu.
You could either save your Excel template with the columns defined, or maybe even better, write a little Excel macro to do it after you've opened the file.
In Windows in control panel on Region and language try to change day month year delimiter. You can try 01/06/2014
Retrieving data ...