how do i turn off auto fill?

G

Guest

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

Guest

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

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get cells auto fill typing 2
How can i turn off the auto fill options button? 1
Change Default Auto-Fill-In month 4
Auto Fill Options 1
Auto Fill Defaults 3
Calculate (Auto Fill) cells with numbers and text. 3
Excel 2007 auto fill help 1
How do I turn off the automatic text suggestion in excel? 2

Top