EXCEL SHORTCUTS
Ctrl+Shift+! formats a number in comma format.
Ctrl+Shift+$ formats a number in currency format.
Ctrl+Shift+# formats a number in date format.
Ctrl+Shift+% formats a number in percentage format.
Ctrl+Shift+@ formats a number in time format.
Ctrl+5 adds a strikethrough to any number.
Stanley Zarowin is a contributing editor to the JofA. His e-mail address is stanley.joatech@gmail.com.
Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to me via e-mail at stanley.joatech@gmail.com or via regular mail at the Journal of Accountancy, 220 Leigh Farm Road, Durham, NC 27707-8110. Because of the volume of mail, I regret I cannot individually answer submitted questions. However, if a reader’s question has broad interest, I will answer it in a forthcoming Technology Q&A column. |