Our company uses a report writer/formatter that creates Excel
spreadsheets and then sends them as email attachments to specified
users. The data being formatted is coming from a file shipped to the
report software from an I5 environment.
The data coming in is in the format mmddyyyy but some of the cells in
the SS are being converted to ddmmyyyy.
When this problem occurs it only happens for months 10, 11, and 12.
These dates are being used in calculations so this is a big problem.
We are using Excel 2003.

Any ideas?