Sorry that should have been the MM/DD/YYYY option.

>Hi Larry,
>
> How about changing the Format Cells Category to Custom and choosing the DD/MM/YYYY Option?
>
>Gavin...
>
>>> I thin
>k the problem is caused by having the Format Cells Category in Excel set to general instead of date. Click on the Column heading in Excel and see what the Format Cells Category is set to.
>>
>>I have tried both settings, it is the same either way.