Excel: The right format is the wrong format

By J. Carlton Collins, CPA

Q. I can't figure out why the decimals and commas in my Excel-based cash flow statement (using the "Accounting Format") don't line up properly (as pictured below). What's going on?

techqa1


A.
The problem is that you have selected the Right Align format, which overrides the Accounting Format's decimal orientation. You can correct this problem by selecting column H, and from the Home tab's Alignment group, making sure the Align Right, Align Left, and Align Center formats are deselected. Thereafter, the numbers will align ­according to their decimals, as pictured below.

techqa2

About the author

J. Carlton Collins (carlton@asaresearch.com) is a technology consultant, a CPE instructor, and a JofA contributing editor.

Note: Instructions for Microsoft Office in “Technology Q&A” refer to the 2007 through 2016 versions, unless otherwise specified.

Submit a question

Do you have technology questions for this column? Or, after reading an answer, do you have a better solution? Send them to jofatech@aicpa.org. We regret being unable to individually answer all submitted questions.

SPONSORED REPORT

6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.

PODCAST

How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.