Shortcuts

Apply date format

Pinterest LinkedIn Tumblr
Apply date format 1

The CTRL + SHIFT + #key helps in applying the date format to the selected range of cells, and numbers therein will be displayed as dates
CTRL + SHIFT + #is a cell formatting that changes numbers to be displayed as a date i.e.. 2958465 changes to 31-dec-99 and 2 is 2-jan-1900.

Related Posts

Write A Comment