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
Select cells for formatting
Highlight the specific cells or range (e.g., B2:B10) that you want to display in currency format.Apply Currency format
Click the "123" icon in the toolbar and choose Currency from the dropdown menu.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 .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.Increase decimal places
To add more precision, click the Increase Decimal icon. This will add decimals back to your values column as needed.Review formatted spreadsheet
Your spreadsheet is now properly formatted with consistent currency values and decimal placement.
FAQs
What formatting options are available for cells in a Spreadsheet Block?
QuoteCloud Spreadsheet Blocks support the common cell formats you need: plain Text, Number, Currency, and Percentage. Use Text for labels, Number for quantities and calculated fields, Currency for financial figures, and Percentage for rate-based values to make tables clear and professional in your sales quoting software or proposal software.
Why is cell formatting important when sharing documents?
Proper cell formatting improves clarity and consistency across shared documents. Choosing the correct data type (Number, Currency, Percentage, or Text) prevents misinterpretation, makes totals and calculations obvious, and ensures tables look professional to clients and colleagues when you send quotes or proposals from your quote software or sales proposal software.
How do I apply formatting within a Spreadsheet Block?
Select the single cell or range you want to format, open the Spreadsheet Block’s formatting controls or context menu, and choose the appropriate data type (Text, Number, Currency, or Percentage). The selected format is applied in one action so you can quickly style cells used in quotes, proposals, or reports.
Can I apply the same formatting to multiple cells at once?
Yes. You can select multiple cells, entire rows or columns, or a rectangular block of cells and apply a uniform format in a single step. This keeps presentation consistent across tables and saves time when preparing sales documents with your sales quoting software or proposal software.
What should I do if numeric values display as text or won’t format correctly?
First confirm the cell contains only numeric characters (no stray letters, currency symbols, or extra spaces). If hidden characters are present, re-enter the value or paste it into a fresh cell. Then reselect the affected cells and use the formatting controls to set Number, Currency, or Percentage. If issues continue, clear formatting on those cells and reapply the correct format; contact QuoteCloud support if problems persist.
How does correct cell formatting affect totals and calculated fields in quotes and proposals?
Using the appropriate numeric formats (Number, Currency, Percentage) ensures that totals and calculated fields render and compute correctly. Proper formatting prevents miscalculations or display errors, making financial figures in your sales quotes and proposals accurate and easy for clients to understand.
Can I format entire rows or columns for currency when preparing invoices or integrating with accounting tools?
Yes. You can apply Currency formatting to full rows or columns so every cell in that range uses the same money format. This is particularly useful when preparing invoices or syncing financial data with accounting integrations like QuickBooks Online, helping maintain consistency between your quote software and bookkeeping records.
How do I clear or reset cell formatting in a Spreadsheet Block?
Select the cells you want to reset and use the Spreadsheet Block’s Clear Formatting option (or equivalent command in the context menu) to remove existing formats. After clearing, reapply the correct data type (Text, Number, Currency, or Percentage) to ensure values display correctly in your quote software or proposal software.