View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default auto correct option

You can preformat the cell as text and then do your data entry.

You can prefix your entry with an apostrophe: '01/01



aavasilenko wrote:

Hello there.

Please say if you know how to switch-off auto correct options from 01/01 -
9-12 to 1st January and 9 December respectively,

Thanks a lot


--

Dave Peterson