For some data types, such as a date or a percentage, Excel will change ... number or a formula. This number format is great when you want to use and display extra long numbers (like credit card ...

If you type "1/1/19" into a cell with the long date format, Excel will change ... with a date to General or Text. Excel will turn your date into an unrelated number. For example, 3/3/2017 becomes ...