Format amounts as US dollars
FormattingHardLLM judge scoringLatest run
Passed by 3 of 12 products on their best model: Autosheet in Excel, Copilot in Excel and Gemini in Sheets.
Prompt
Show the amounts as US dollars ($) with two decimal places, regardless of the workbook or system locale.
Starting spreadsheet
Orders| A | B | C | |
|---|---|---|---|
| 1 | Order | Customer | Amount |
| 2 | O-1001 | Northwind | 1250 |
| 3 | O-1002 | Contoso | 980.5 |
| 4 | O-1003 | Fabrikam | 2100 |
| 5 | O-1004 | Adventure Works | -175.25 |
A passing output
Autosheet in Excel · Opus 5.5Pass criteria
All must be met, checked by an LLM judge.- All amounts in C2:C5 use a US-dollar currency format rather than the workbook or system locale's default currency.
- Currency symbols, thousands separators, and exactly two decimal places are visible.
- The underlying numeric values remain unchanged and remain numbers rather than being rewritten as text.
- The actual final spreadsheet images clearly show all four amounts in Orders!C2:C5 in full within column C, including the dollar symbol, all digits, the sign where applicable, and both decimal places. Fail if any target amount is replaced by hash marks (#####), clipped, truncated, abbreviated, shown in scientific notation, or otherwise not fully readable. Correct stored values or number-format codes alone do not satisfy this checkpoint.
Passed 5
Autosheet in Excel Opus 5.5 · Medium
Autosheet in Excel Sonnet 5.5 · Medium
Autosheet in Sheets Haiku 5.5 · High
Copilot in Excel Auto
Gemini in Sheets Auto
Failed 17
Autosheet in Excel GPT-6 Astra · Low
Why it failed: Currency symbols, thousands separators, and decimal places are not visible because the cells display hash marks (######).
Autosheet in Sheets Opus 5.5 · Medium
Why it failed: Two decimal places are not fully visible due to column truncation; C2 and C4 are cut off right after the decimal point, and C5 is cut off after the first decimal digit.
Claude in Excel Opus 5.5 · High
Why it failed: The dollar format is applied, but the column is too narrow: the amounts show as ######.
Autosheet in Excel Haiku 5.5 · High
Why it failed: In the final rendered spreadsheet image (Document 1), all four values in Orders!C2:C5 are replaced by hash marks (######) due to insufficient column width.
Claude in Sheets Opus 5.5 · Medium
Why it failed: Exactly two decimal places are not fully visible in C2, C4, and C5 due to clipping at the column boundary.
Claude Code + Sheets MCP Opus 5.5 · Medium
Why it failed: Exactly two decimal places are not visible for all amounts; C2 and C4 only display one decimal place due to column clipping.
Autosheet in Excel GPT-6.1 Sol · Medium
Why it failed: The currency symbols, thousands separators, and decimal places are not visible because the cells render as '######'.
Claude Code + Autosheet MCP Opus 5.5 · Medium
Why it failed: Exactly two decimal places are not visible for C2 and C4, which display as '$1,250.0' and '$2,100.0' due to clipping.
ChatGPT + Autosheet MCP GPT-6 · Medium
Why it failed: Exactly two decimal places are not visible for all amounts; C2 and C4 only display one decimal place due to column clipping.
ChatGPT in Excel GPT-6 Astra · Medium
Why it failed: The dollar format is applied, but column C is too narrow: the amounts show as ######.
Claude in Excel Haiku 5.5 · High
Why it failed: The number format applied used Euro ("€"#,##0.00) rather than a US-dollar currency format.
Claude in Sheets Haiku 5.5 · High
Why it failed: In the final rendered sheet image, the amounts in C2, C4, and C5 are clipped/truncated at the right edge of column C (e.g., '$1,250.', '$2,100.', and '($175.2').
Autosheet in Excel GPT-6 Luna · High
Why it failed: Currency symbols, thousands separators, and decimal places are not visible because the cells display hash marks (######).
ChatGPT + Drive MCP GPT-6 · Medium
Why it failed: Exactly two decimal places are not visible for all amounts; C2 and C4 only display one decimal place ($1,250.0 and $2,100.0) due to truncation.
ChatGPT in Excel GPT-6 Luna · High
Why it failed: In the actual document image, all four values in Orders!C2:C5 are replaced by hash marks ('######') because column C is too narrow.
ChatGPT in Sheets GPT-6 Astra · Medium
Why it failed: Two decimal places are not visible across all cells; C2 and C4 are cut off at the decimal point ('$1,250.' and '$2,100.') and C5 is cut off after the first decimal digit ('-$175.2').
ChatGPT in Sheets GPT-6 Luna · High
Why it failed: The actual final spreadsheet screenshot shows C2, C4, and C5 clipped by the column boundary (showing '$1,250.', '$2,100.', and '($175.2' respectively), failing readability requirements.