exporting from SAP to Excel
 

I export data from SAP to Excel 2007 once a week. Up until last week I had
no problem. The numerical data downloaded into Excel as an exponential
number and I converted it to the number with comma format.

This week, however, the number downloaded as #:##########E+6 (example
9:23456000000E+6). Because of the colon, Excel is reading this as text and
will not convert to the correct number.

I logged into someone elses computer and did not have this problem. Is
there a setting in Excel that needs to be changed?