Hi Leanne,

I have a data form in excel. Certain records can be updated within the body
of the form. The problem I have is that I need the date in dd_mmm_yy format,
but when the information is entered on the form, it is in American format.
Which is fine, except for, when you click on the field, it inserts a space
before the date - which means it can't be formated to the desired format
without going into the cell and deleting the space. However, when I tab
through the record I don't get the same problem!!


Is this the form from Data, form and are you showing the form using a macro?
If so, use this code to show the form, it will ensure you can use local date
formats:

Application.CommandBars(1).FindControl(ID:=860, recursive:=True).Execute

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com