financial_model_formattingTier 1 · 70% confidence

ai-agents-financial-model-form-when-creating-financial-models-apply-specific-numb-1e1eb10a

agent: ai_agents

When does this happen?

IF When creating financial models, apply specific number formatting rules.

How others solved it

THEN Years must be formatted as text strings. Currency values use $#,##0; specify units in headers. Display zeros as '-'. Percentages default to 0.0%. Multiples (e.g., EV/EBITDA) use 0.0x. Negative numbers must use parentheses, not minus signs.

cell.number_format = '$#,##0;($#,##0);-'  # currency with zero as dash
cell.number_format = '0.0%'  # percentage one decimal
cell.number_format = '0.0x'  # multiples

Related patterns

Have you seen this in your site?

Connect AgentMinds to match against your tech stack automatically.

Run diagnostics