I'm finding that the sforce Excel Connector (5.51) is loading date fields from Salesforce records to Excel inconsistently.

Dates which display in Salesforce such as 3/02/2005 (3rd of Feb to us Aussies) when loaded via the Connector display as 2/03/2005 in Excel with a cell type of "v" for value. Others such as 25/10/2004 when loaded display as 25/10/2004 in Excel with a cell type of "l" for literal.

The cells are set with a format of Date, Locale: English (Australia). Note: Users in my company have an sforce locale of English (Australia).

It seems that any date that could be interpreted as mm/dd is loaded that way as a true date with those that can't be loaded as literals.

I have just notice this and am part way through migrating some changes.

Thanks in advance for your assistance.

Michael