How to format tables with monetary data?
I am working on a web app that needs to display revenue data in a table, and I am not quite sure how to make it easy to read.
Are there are any style guides or manuals that can help me?
For instance, what are the rules about zero values? Should I put n-dash, zero, or just leave the cell empty?
Should I get rid of dollar sign, or just leave it for "total" column/row?
For numbers less than $1, can I omit zero so that 0.31 becomes .31? Would the same rule apply to totals?
Date Foo Bar Total
Jan 23 $0.31 $0.00 $0.31
Jan 24 $0.01 $9.06 $9.07
Jan 25 $0.10 $0.00 $0.10
Jan 26 $0.00 $0.04 $0.04
Total $0.42 $9.10 $9.52