Excel 97 Form
 

Hi, I would be really grateful if someone could help out as I am bashing my
head against a wall over here!
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 there anyway I can just make it in the above format?
Very grateful for any assistance.