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 firstname.lastname@example.org.
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 email@example.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.