After several attmepts at solving this, I still seem to be having a problem with date formats changing.

I have a data entry form set up feeding information to a worksheet. When the sheet updates the dates on the form automatically change to a US format (mm/dd/yy) I have formatted the colums to date and selected the correct format. This has corrected some changes, but future entries still come up in MM/DD/YY.

I have tried using text to columns as advised by some kind soul on this forum, and I thought it was working but alas no.

Is there a way I can get the data form to insist on the correct format to be used, and then perhaps format the column on the worksheet to TEXT so that it wont change? If so How do I do it?

This is beginning to make me lose even more hair than before, and when I started this I had a full head of hair, Just like Michael Bolton, I'm more like Phil Collins now- (I don't like either artist so it shows how annoying this problem is.

Any help would be greatfully recieved.

Cheers