View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
ann ann is offline
external usenet poster
 
Posts: 210
Default Change Date Format

I'm new to Excel 2007. My problem is that I do not know how to stop Excel
from automatically converting text to a date format. For example, when I
enter data in a cell such as: Smith v Jones 06-91, Excel automatically
changes 06-91 to Jun-91. Data entered as Smith v Jones 06-3412 remains
06-3412. How do I stop Excel from automatically changing 06-91 to Jun-91?
"06" does mean June but it should stay as "06".

Thanks.