Excel Shortcuts

BY STANLEY ZAROWIN

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.

 

©2008 AICPA

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.