how do i turn off auto fill?

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Autofill isn't your problem, the cell you are using is formatted as a date.
Change the format to general
 
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

Auto fill not working 2
Turning off the month function 3
How do I get cells auto fill typing 2
How do I turn off the automatic text suggestion in excel? 2
Auto Fill Options 1
How can i turn off the auto fill options button? 1
Change Default Auto-Fill-In month 4
Turn Auto recalculation off during macro execution 4

Back
Top