Excel Date Text Converter Guide: Text to Date, Serial Fix, Green Triangle

2026-07-11

  • Excel
  • date
  • text to date
  • CSV
  • serial number
  • online tool
  • tutorial

Why Excel dates become text or numbers

CSV exports from ERP/CRM and copy-paste from web tables often cause:

  1. Text dates — shows 2024-01-01 but left-aligned, green triangle, cannot sort
  2. Serial numbers — shows 45292 instead of a readable date (Excel OADate)
  3. Mixed formats — 01/02/2024 and 2024-01-02 in the same column

ComTools Excel Date Text Converter fixes these online without Excel installed.

Steps

  1. Open Excel date converter
  2. Upload .xlsx or .csv (header row required)
  3. Choose mode:
    • Text → Date — fix CSV text dates, green triangle
    • Date → Text — export fixed yyyy-MM-dd strings
    • Serial → Date — convert 45292 etc. to real dates
  4. Select target columns (date/time headers auto-selected)
  5. Preview conversion — review success/fail stats
  6. Download XLSX

Long-tail quick reference

Search intent Mode Guide page
excel text to date online Text → Date Text to date
excel date to text / TEXT function Date → Text Date to text
45292 to date / serial number Serial → Date Serial to date
green triangle / number stored as text Text → Date Green triangle fix 
CSV to Excel → date converter → Excel Format → Excel to SQL

vs Excel desktop

Scenario Excel ComTools
Batch text to date Text to columns, per column Multi-column, one click
45292 to date Change format or formula Auto OADate
CSV direct Open first Upload directly
Preview None Sample rows + stats

Topic guides

中文版