Numbers and Currency fields should have number of decimal cases and be right aligned

This way, no matter the number inputed, units, tens, hundreds, thousands and decimal cases will always be aligned with each other, no matter the number inserted, allowing you to mentally calculate or compare numbers in a column.

Compare these 3 columns in Excel

First has left alignment and each record has a different number of decimal cases. It’s hard even to tell which number is bigger and which is smaller, and much harder to mentally sum or analyze them.

The middle has right alignment, but it’s not worth much if you don´t set a max number of decimal cases.

In the right, right alignment, decimal cases and formatting. Very easy to compare numbers, or to sum for example only the thousands, for a rounded “1.017 thousands” fast sum.

1 Like