Thread: Date Formatting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TheRiverT TheRiverT is offline
external usenet poster
 
Posts: 1
Default Date Formatting

I am trying to enter the date September 19 and I do not want the year tacked
on.
Everytime that I type "September 19" and press enter, Excel automatically
changes it to 19-Sep or when the cell is highlighted it is 9/19/09. How can I
turn off automatic formulas and editing and what not?