How do I stop Excel from turning November 2006 into Nov-06?

J

Jessamine

Excel is driving me mad. How can I permanently turn off the function which
converts dates entered as November 2006 to Nov-06?
 

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

Date Entry Problem 4
Searching for records with multiple criteria 7
Mail Merging Dates from Excel -> Word Simple Problem! 1
How to calculate with workingdays instead of calendar days 4
add time with out weekends 3
Subtotals 2
Excel not recognizing dates as dates 1
How to sort data from rows into columns? 6

Top