Pad IDs with leading zeros
FormulasEasyDeterministic scoringLatest run
Passed by all 12 products on their best model.
Prompt
Use formulas in G2:G5 to display every ID as six digits with leading zeros.
Starting spreadsheet
People| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | ||
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | ||
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | ||
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 |
A passing output
Autosheet in Excel · Opus 5.5G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.G2:G5hold the expected values, from formulas
Passed 22
Autosheet in Excel Opus 5.5 · Medium
Passed9s · 3¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Excel GPT-6 Astra · Low
Passed6s · 5¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Sheets Opus 5.5 · Medium
Passed10s · 3¢
G2=TEXT(F2, "000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Excel Sonnet 5.5 · Medium
Passed4s · 0.9¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude in Excel Opus 5.5 · High
Passed10s · 6¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Excel Haiku 5.5 · High
Passed5s · 0.1¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude in Sheets Opus 5.5 · Medium
Passed14s · 4¢
G2=TEXT(VALUE(F2),"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed23s · N/A
G2=TEXT(VALUE(F2),"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Excel GPT-6.1 Sol · Medium
Passed8s · 2¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed30s · N/A
G2=TEXT(VALUE(F2),"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed33s · N/A
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Sheets Haiku 5.5 · High
Passed13s · 0.1¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT in Excel GPT-6 Astra · Medium
Passed14s · 39¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude in Excel Haiku 5.5 · High
Passed6s · 0.4¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Claude in Sheets Haiku 5.5 · High
Passed15s · 0.9¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Autosheet in Excel GPT-6 Luna · High
Passed7s · 0.1¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Copilot in Excel Auto
Passed14s · N/A
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT + Drive MCP GPT-6 · Medium
Passed28s · N/A
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT in Excel GPT-6 Luna · High
Passed23s · 0.4¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
Gemini in Sheets Auto
Passed37s · N/A
G2=TEXT(F2, "000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT in Sheets GPT-6 Astra · Medium
Passed24s · 31¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |
ChatGPT in Sheets GPT-6 Luna · High
Passed22s · 0.3¢
G2=TEXT(F2,"000000")
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | First Name | Last Name | Full Name | Domain | ID | Padded ID | |
| 2 | Ana | Martinez | Ana Martinez | …@example.com | 42 | 000042 | |
| 3 | Jean | Van Damme | Jean Van Damme | …@contoso.fr | 381 | 000381 | |
| 4 | Mina | Okafor | Mina Okafor | …@northwind.co.uk | 7 | 000007 | |
| 5 | Luca | Bianchi | Luca Bianchi | …@fabrikam.com | 9102 | 009102 |