View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default how do i turn off auto fill?

Autofill isn't your problem, the cell you are using is formatted as a date.
Change the format to general

"nia1989" wrote:

every time i try to type "5-8", excel automatically replaces it with
"05-Aug". I've been into the options tab and turned off auto fill, but this
didn't solve the problem. How can I stop this from happening?