Thread: How do I remove from excel automatic date function?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I remove from excel automatic date function?
You can preformat the cell as Text (format|cells|number tab), then do your data
entry.

Or you can prefix your entry with an apostrophe: '2-28-6



Need Help wrote:

I would like to know if its possible to stop the function in excel that
automatically changes numbers such as 2-28-6 into 2/28/2006.

--

Dave Peterson
Reply With QuoteReply With Quote