View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chris K. Chris K. is offline
external usenet poster
 
Posts: 2
Default Auto date in excell 2010

When I type a number into a cell, Excel automatically creates a date from it,
even if it is just one number like 10 or 4 or 1 or 7. How can I get this to
stop, it is very annoying because I can't enter just a number into the cells
without it turning into a date unless I put a * or some other symbol before
or behind the number.