The date will display in the format you choose, no matter how you enter it. If you type "1/1/19" into a cell with the long date format, Excel will change it to the expanded date.

Custom number format in Excel lets you define the color of the text in selected cells according to their values. What's more, ...

If the numbers keep changing to dates in Microsoft Excel, you can use the following methods to fix the issue: Format cells as text. Insert an apostrophe before the number. Use Paste Special.

Select all the cells you want to modify, and right-click on them. Select Format Cells. Go to the Number tab. In the Category list, click Date. Under the Type list, choose the date format you want on ...

Set Current Date in Excel The easiest way to add the current date in Excel is to simply type the date. For instance, typing "2018-07-31" in a cell is automatically detected as a date.