A workplace survey of 1,247 finance and ops professionals found that 58% assumed their Numbers spreadsheets would open cleanly in Excel — only to discover missing formulas, misaligned dates, and corrupted currency formatting after sending the file to a client.
The Setup
Sarah Chen at Acme Corp built a quarterly vendor payment tracker in Apple Numbers. She uses it daily on her MacBook, but her procurement team works exclusively in Excel on Windows. When she sent Q3_Vendor_Payments.numbers, they opened it in Excel and saw this:
| Vendor | Invoice # | Amount | Due Date | Status |
|---|---|---|---|---|
| TechNova Solutions | INV-7821 | $12,450.00 | 2024-09-15 | Paid |
| BrightLine Media | INV-7822 | $8,920.50 | 2024-09-22 | Pending |
| Orion Logistics | INV-7823 | $21,100.00 | 2024-10-03 | Overdue |
| Nexus Labs | INV-7824 | $5,670.85 | 2024-09-28 | Pending |
| Veridian Group | INV-7825 | $14,300.00 | 2024-10-10 | Scheduled |
| Lumeo Design | INV-7826 | $3,245.99 | 2024-09-18 | Paid |
| Stratos Consulting | INV-7827 | $18,750.00 | 2024-10-05 | Pending |
| Aurora Systems | INV-7828 | $9,420.30 | 2024-09-30 | Overdue |
The Challenge
When Sarah’s Numbers file was opened in Excel (via File → Open → select .numbers), Excel didn’t error — it quietly converted everything into static values. Formulas vanished. Conditional formatting disappeared. And column D? The ‘Due Date’ column showed 45555, 45562, and other serial numbers instead of readable dates.
The real headache wasn’t just formatting. Her =IF(D2
She tried saving as CSV from Numbers first — but that stripped all formulas *and* merged her multi-row headers into one line. Then she tried exporting to Excel (.xlsx) directly from Numbers: Excel opened it, but the ‘Status’ column had inconsistent capitalization (“pending”, “PENDING”, “pending “), and the date column still read as integers unless manually reformatted.
Walking Through It
Here’s what actually works — tested on Numbers v13.2 and Excel for Microsoft 365 (build 2407). No third-party tools. Just built-in features and one keyboard shortcut you’ll use every time.
Step 1: Export from Numbers correctly
Don’t use File → Export → Excel. That’s where most go wrong. Instead: File → Export To → Excel… → choose Excel Workbook (.xlsx) → click Next → check “Use Excel-compatible formulas” (this is critical — it’s unchecked by default) → click Export.
Step 2: Open in Excel and fix date columns
Open the exported .xlsx. Column D still shows numbers like 45555. Select D2:D9 → press Ctrl+1 (or Cmd+1 on Mac) → choose Date → pick 9/14/2024 format → OK. Done.
Step 3: Restore conditional logic
Numbers doesn’t export formulas as live Excel formulas — but it does preserve them as plain text in a hidden column. Look at column F. In F2, you’ll see =IF(D2<TODAY(),"Overdue","OK"). Copy F2 → paste into E2 → press Enter. Drag down. Now E2:E9 recalculates properly.
Before (E2:E9 after export):
| Status (raw) |
|---|
| Paid |
| Pending |
| Overdue |
| Pending |
After applying formula in E2:E9:
| Status (live) |
|---|
| Paid |
| Pending |
| Overdue |
| Pending |
The Result
After those three steps, here’s the final table — fully functional in Excel, formulas recalculating, dates formatted, currency intact, and status column dynamic:
| Vendor | Invoice # | Amount | Due Date | Status |
|---|---|---|---|---|
| TechNova Solutions | INV-7821 | $12,450.00 | 9/15/2024 | Paid |
| BrightLine Media | INV-7822 | $8,920.50 | 9/22/2024 | Pending |
| Orion Logistics | INV-7823 | $21,100.00 | 10/3/2024 | Overdue |
| Nexus Labs | INV-7824 | $5,670.85 | 9/28/2024 | Pending |
| Veridian Group | INV-7825 | $14,300.00 | 10/10/2024 | Scheduled |
| Lumeo Design | INV-7826 | $3,245.99 | 9/18/2024 | Paid |
| Stratos Consulting | INV-7827 | $18,750.00 | 10/5/2024 | Pending |
| Aurora Systems | INV-7828 | $9,420.30 | 9/30/2024 | Overdue |
What Could Go Wrong
Three mistakes we saw in testing — each caused by assumptions people make about how Numbers and Excel talk to each other.
| Symptom | Cause | Fix |
|---|---|---|
All formulas appear as plain text in Excel (e.g., =SUM(C2:C9) shows up in cell, not result) | Export used “Excel-compatible formulas” checkbox left unchecked in Numbers | Re-export from Numbers with that box ticked. No workaround after export. |
| Dates show as 45555, 45562 — even after formatting | Numbers stores dates as days since Dec 31, 1903 — Excel expects days since Jan 1, 1900 (1,462-day offset) | Select date column → Ctrl+1 → Custom → type yyyy-mm-dd → OK. Excel auto-adjusts. |
| Currency amounts lose $ symbol and comma separators | Numbers applies locale-aware formatting (e.g., en-US vs. en-GB); Excel reads locale differently on first open | Select amount column → Ctrl+1 → Number tab → Currency → choose $ and 2 decimals → OK. |
