Thread: How do I stop a date from automatically updating?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default How do I stop a date from automatically updating?
What value do you want in the cell when you type Nov-05?


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Canwoman88" wrote:

When I type a registration date in a database, such as Nov-05, and press
enter, the year automatically updates to 06. How can I stop the update?
Reply With QuoteReply With Quote