This article describes how to format cells in Q. For example, how to increase the number of decimals places, show a percentage sign, etc.
Method - Use the toolbar options
You can increase or decrease the number of decimal places, show percentage signs, add the $ symbole, hide rows and columns with only zeroes, and color the background of cells to highlight interesting results by using the formatting toolbar buttons ().
Method - Format decimal places for different statistics
If you wish to set different numbers of decimal places for different statistics:
- Right-click on the table.
- Select Table Options > Decimal Places.
- Set the number of decimals as desired for each statistic, otherwise, leave it blank if you wish to use the project's settings.
If you wish to make these changes to every table, do this via Edit > Project Options > Customize > Decimal Places.
More advanced modifications can be done using Rules and via Table JavaScript and Plot JavaScript.
Next
How to Color Significant Table Cells
How to Modify Table Cells Using a Rule