Hi,

I think you might need to go to control panel and check the regional
settings are set to the UK date format

when typing 1/2 what do you mean, a half or 1 out of two? the best thing is
to put a ' before it when you type it



"m.beebee" wrote:

I have two problems with regards to date auto correct:
1) when i enter 4/6 - ie 4 June as i want ddmmyyyy - it automatically
changes to 06-Apr when i actually want 04-Jun. I have looked through all the
options i can find and changed defaults to yyyymmdd (although i would like is
at ddmmyyy, but that is not an option on the list).
2) secondly i sometimes need to have a cell that says 3/4 or 1/2 without it
automatically chaging this to a date. how do i switch this off?