For example, Excel will automatically choose the date format for a cell that contains 11/11/19. You can set Excel to display dates in a variety of ways, no matter how you type in the data.

If you need a custom format for the timestamp, use the TEXT() function before pasting it as values. That’s it! I hope you find this useful. Read: How to show file path in the title bar in Excel ...

One of Excel's most underrated features for ... In the example above, =TODAY() formula returns the current date, and you can format the cell background red or use bold red text.