My Systems:
1) Apple MacBook OSX 10+ using Excel 2000
2) PC Notebook with XP using Excel 2000

The following occurs in both systems...

I am adding data to a database using DataForm. Three of the fields within the database are Dates. I have formatted the cells on the worksheet as 'dd mmm yyyy'.

When using the DataForm from within the Worksheets all is fine, the format within the dataform shows as it has been inserted, 'dd/mm/yy'

However, having created a macro to show the DataForm for input, and despite having entered the dates using the format 'dd/mm/yy', when I return to the dataform, via the macro, I note that the Date Format has been altered to show as 'mm/dd/yy'. It is fine for me, however, for the person who has no experience with DataForms or even Excel it could be quite disconcerting.

The default setting for both systems have been set correctly.

Any clues?