• LinkedIn
  • YouTube
  • Twitter
  • Facebook
  • Google+

Keyboard Shortcuts: Excel

Get PDF file

by on
in Excel Training,Keyboard Shortcuts,Office Technology

Ctrl+Shift+3 Dates may change to serial numbers when imported. Use Ctrl+Shift+3 (#) to change serial number dates formatted as numbers back to dates (43160 becomes 1-Mar-2018). You can then apply any other date format.

Ctrl+Shift+2 Imported time stamps sometimes show up as decimal values. Change time expressed as a number with Ctrl+Shift+2 (@). For example, .5 would become 12:00 PM.

Ctrl+Shift+` Use Ctrl+Shift+` (~) to change any formatted numbers back to general format. For example, this would change 1-Mar-2018 to 43160, and 12:00 PM to .5.

Leave a Comment