View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
m.beebee m.beebee is offline
external usenet poster
 
Posts: 1
Default date auto correct

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?