View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default auto date annoying

Sproul wrote:
how can you put information like this "19-2" in a field
without it being changed to a date format


You can prefix the data entry with an apostrophe ('). I usually
lack the foresight to format the cell as Text before entering the
data. Changing to Text format after the fact results in a number,
the internal value of Excel dates.