Configuration Properties - Bill of Materials Options

On one of our parts we have the Configuration Bill ofMaterials Options set to "User Specified" to display our partneumbeon the BOM.

All of our in-house part numbers are in the millions ie (1002395)If we edit the design table using Excel these User Specifiednumbers are changing to "1.00E+06"

If the configs are edited in SW the numbers seem to stay, problemseems to be from Excel.

System Specs:
SolidWorks Office Premium 2008 SP5.0
PDMWorks Enterprise 8.4 B168
Dell T5400, Xeon CPU x5450 @ 3.00Ghz, 3.25 GB Ram
XP Pro SP3
nVidia Quadro FX 4600
Microsoft Office Excel 2007SolidworksParts And Features