Take the 2-minute tour ×
User Experience Stack Exchange is a question and answer site for user experience researchers and experts. It's 100% free, no registration required.

I have a grid with columns that are formatted as cents and dollars. By default, the tender and amount columns are being formatted as integers, but for the total we are formatting it as 2 decimal places (.00).

tender   qty   amt

$5       1   5
$10      1   10
$100     1   100
5¢       1   5
10¢      1   10

total    5  115.15

What is the correct way to format the cents and dollars in the amount column?

share|improve this question
    
The Tenders and amt are right aligned in actual grid... but not shown here –  RajKumarLoganesan Feb 26 at 10:05

3 Answers 3

If you're going to display this in a UI, consider alternating the row background colors - between white and a faint/light color of your choice for easier reading.

You can choose to also style your headers row and totals row, but make sure they're readable.

In order to ensure proper right-alignment, use a mono-spaced font. The slightest misalignment of that decimal point is bothersome to many, which will happen if you use a font that has varying character widths.

share|improve this answer

Consistency is key here I think.
So, for currency, always use two decimals and align every number to the right.

It took me some time to make sense of the table you displayed in your post. I would go for something like this:

tender    qty    amt

  5.00      1      5.00
 10.00      1     10.00
100.00      1    100.00
  0.05      1      0.05
  0.10      1      0.10

total       5    115.15
share|improve this answer
4  
You also want to align your headers the same way as the rest of the columns they're in, so the eye can scan down them cleanly. Usually, your first column is left aligned, and all other columns and headers are right aligned, to distinguish the lookup column from the data columns. This book covers this sort of table formatting in great detail –  Racheet Feb 26 at 12:39
1  
Two decimals is correct for USD and many others but wrong for some currencies –  Mark Feb 26 at 18:45
    
Also, it would be good to keep the $ (or ¥ or whatever) off to the side, to make it totally obvious what the number represents, rather than drop it completely –  Izkata Feb 26 at 22:50

I would suggest keeping the amount in dollars at all times. Cent values can be shown as decimal dollar values.

Also, you can always have tender and amt columns to show values right-aligned and up to 2 decimal places. This will make values more presentable and less confusing.

share|improve this answer
    
I disagree, if the user is using the table to work out which physical coins useed in a transaction, which seems to be the intended purpose, then you want the lookup column to have the denominations of the coins/notes, not to be a dollar value for cent coins. –  Racheet Feb 28 at 14:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.