Excel 101 - Why Does Typing 12-13 Becomes 13-Dec?: Episode 1561

2,804 views · Published 19 June 2012 · 2:24 · Indexed 12 November 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: Why Excel changes your data entry to a date or scientific notation.

Welcome back to another episode of Don't Fear the Spreadsheet, where we tackle all your Excel woes and make you an expert in no time. In today's episode, we have a question from Tyler Nash who is frustrated with Excel changing his input of 12-13 to December 13. But fear not, Tyler, because I am here to explain why Excel does this and how you can easily fix it.

First of all, Excel is trying to make your life easier by recognizing anything that looks like a date and converting it to a real date. This is helpful for those who are actually trying to input dates, but for those who are not, it can be frustrating. The solution? Simply add an apostrophe before typing in your numbers. This tells Excel to treat it as text and not convert it to a date.

Now, you may be wondering why an apostrophe is the solution. Well, it goes back to the days of Lotus 123 and VisiCalc, where the apostrophe was used to indicate that the input was not a number. This was a shortcut for changing the format to text, which is what we are essentially doing when we add the apostrophe before our numbers. So, next time you want to input something that looks like a date but don't want it to be converted, just remember to add that apostrophe.

But wait, there's more! If you don't want to use the apostrophe, there is another solution. You can change the format of the cell to text before typing in your numbers. This will prevent Excel from converting your input to a date. However, most people find it easier to just use the apostrophe. And for those who are new to Excel, don't worry, we've got you covered. Check out our book, "Don't Fear the Spreadsheet," which breaks down all the Excel basics in an easy-to-understand way. Trust me, after reading this book, Excel for Dummies will look like it was written for rocket scientists. Thanks for tuning in and see you next time on Don't Fear the Spreadsheet!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Table of Contents:
(00:00) Introduction to Don't Fear the Spreadsheet podcast
(00:10) Issue with Excel changing numbers to dates
(00:20) Today's question from Tyler Nash
(00:44) Explanation of Excel's automatic date recognition
(01:02) Solution for avoiding date conversion
(01:18) Background on the use of apostrophes in Excel
(01:47) Shortcut for changing format to text
(02:07) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial


This video answers these common search terms:
Apostrophe in Excel
Changing date to text in Excel
Don't Fear the Spreadsheet book
Don't Fear the Spreadsheet podcast
Episode 1
Excel date format
Excel for Dummies alternative
Formatting cells to text in Excel
Handling dates in Excel
Lotus 123 and VisiCalc
MrExcel Tyler Nash
Shortcut key for entering text in Excel


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153371/

So, when typing a few numbers into a cell do you find that sometimes those numbers are changed to a date? Well...what if you didnn't want a date? What if you wanted the numbers in that cell to remain exactly the way you typed them in? Following along with episode #1561, find out why your numbers have changed, why Excel thinks that its a good idea to do that and -most importantly- what you can do to keep the numbers in the cell just the way you entered them into it!

"Don't Fear The Spreadsheet:A Beginner's Guide To Overcoming Excel's Frustrations" by Tyler Nash, Kevin Jones, Tom Urtis and Bill Jelen http://www.mrexcel.com/dftss_home.html

Many 'Beginner Oriented' Excel How-To books say they can bring you from zero to familiar with the important features of Microsoft Excel - 'Don't Fear The Spreadsheet' actually will. Why are we so confident? Because the questions in this book were asked by an absolute Excel Beginner - Tyler Nash - with the answers provided by three (3) Microsoft MVPs specializing in and dedicated to teaching others Microsoft Excel, from the ground up - Kevin Jones, Tom Urtis and Bill Jelen

"This Book Makes Excel For Dummies™ Look Like It Was Written For Rocket Scientists!" http://www.mrexcel.com/dftss_home.html

More from this channel