1
Select cells for formatting
Highlight the specific cells or range (e.g., B2:B10) that you want to display in currency format.
Formatting Cell Content in Spreadsheet Blocks
Apply formatting to cells in a Spreadsheet Block, adjusting text, numbers, currency, or percentages for professional, easy-to-read tables.
Formatting cell content (text, numbers, currency, percentages)
- Learn how to format price values in your spreadsheet.
- Understand how to adjust decimal places and calculate totals.
Steps to format cell content
2
Apply Currency format
Click the "123" icon in the toolbar and choose Currency from the dropdown menu.
3
Format Total cells
Select the cell containing your total calculation (e.g., D2) to apply the same formatting.
Again, select the "123" icon and choose Currency.
4
Decrease decimal places
If you want to simplify the view, click the Decrease Decimal icon in the toolbar.
This removes extra zeros from the end of your currency values.
5
Increase decimal places
To add more precision, click the Increase Decimal icon.
This will add decimals back to your values column as needed.
6
Review formatted spreadsheet
Your spreadsheet is now properly formatted with consistent currency values and decimal placement.
FAQs