View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 287
Default how do i turn off auto fill?

As RajKohli says, format cell as text OR input as '5-8

"RajKohli" wrote:

Excel is assuming your number 5-8 as date.

1. Right-click on the Column Heading (e.g. A, B, C to select entire column
or made a particular selection as required) and choose Properties.
2. From General tab choose Text as Category and click Ok.

Hope this help, let us know!

"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?