Transatlantic trainer David H Ringstrom shows how to expand your formatting repertoire from cell colours and shades to include number formats.
Formatting decimal places is reasonably simple, but can cause grief for spreadsheet users. For example, if your list includes both large and small numbers, there’s a conflict between rounding the small numbers to whole values or adding trailing zeros, which would make the large numbers harder to read.
The tips in this article will simplify that conundrum; first by using a custom number format to add decimal places; and secondly by combining the MOD function with Conditional Formatting to achieve the same end.
Below is a sales report showing currency amounts in columns C and D, with common formats for each column. Column A, however, displays the amount in cell A2 as 3,383.00. How do you present this figure as 3,383, while simultaneously showing the amount in cell A3 as 0.50?
Register for free and log into AccountingWEB to see the full tutorial.
David Ringstrom CPA is the head of Atlanta-based software and database consultancy Accounting Advisors. He presents Excel training webcasts for CPE Link and AccountingWEB.com as well as contributing articles on Excel to AccountingWEB and Microsoft Professional Accountant's Network newsletter. He can be reached by email at david[AT]acctadv.com. More Excel tips from David H Ringstrom available here.