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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920