At times keyboard shortcut seem random, but there is logic behind them. to format a number as a currency, percentage etc.
- Ctrl + ! : Format as Number with decimal point two (eg. 2.50)
- Ctrl + @ : Format as Time (eg. 12:00 PM)
- Ctrl + # : Format as Date (eg. 02-Jan-00)
- Ctrl + $ : Format as Currency (eg. $2.50)
- Ctrl + % : Format as Percentage (eg. 250%)
- Ctrl + ^ : Format as Scientific (eg. 2.50E+00)
Let us know what we have missed in the comments.
Learn & Acquire 