View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gw Gw is offline
external usenet poster
 
Posts: 5
Default Stopping Excel from reformatting data as a date?

When entering data which could be seen to be a date, such as the characters
14/1 meaning Under 14 division 1 which is a soccer team, Excel overrides the
general format of the field and converts the data to date format. There are
many other instances where Microsoft feels it knows better than me the type
of data I am trying to enter. Is it possible to prevent this from happening?