Select the range you want to type the data number and right click to open the context menu and click Format Cells. Click Number tab and select Text from the Category list. See screenshot: Now you can type the number data into the range and it cannot be auto formatted as date.See screenshot: Note: The above two methods cannot work when the number data has been typed already.
Not all bad dates end with you running to post a sad status update or Tweet about it.When you’re typing dates on a cell-by-cell basis in Excel, Excel may jump the gun and format them for you.When it does, you’ll see a small button with an icon of a lightning bolt.The button triggers a menu from which you can fine-tune the fill process so it picks up only the formatting or only the data values of the cell from which you started filling. Mott has extensive experience writing advertising copy for everything from kitchen appliances and financial services to education and tourism.She holds a Bachelor of Arts and Master of Arts in English from Indiana State University.When the "Capitalize..." option is enabled, Word Perfect automatically capitalizes most words that follow a period or an exclamation point, which the program assumes is "end of sentence" punctuation.If that option is disabled, Word Perfect will not automatically capitalize words that follow a period or an exclamation point.Whenever you eneter numbers separated by a hyphen in Microsoft Excel, it automatically converts that data into date format.Suppose you type “2-2” in Excel it becomes “02-Feb” automatically, so to prevent this automatic formatting of numbers into date in Excel follow simple steps below.In Excel, when you type a string number like “2014-6-1” or “1/2” into a cell, it will auto format this number to date “6/1/2014” or “2-Jan”.Sometimes, you may think this auto formatting is annoying, now I tell you how to stop auto formatting number to date in Excel.