Tool 03
📅 Fix Date & Number Formats
Turns dates stored as text into real Excel dates, shows long numbers in full instead of 1.23E+11, converts numbers stored as text (like "$1,250.00") into real numbers and restores lost leading zeros in ZIP codes.
🔒 Works offline — your file never leaves your computer
This page loads nothing from the internet. Try it with your Wi-Fi turned off. Your original file is never changed — you save a cleaned copy.
⚠️ Always keep a copy of your original file as a backup. Check the cleaned copy before you use it.
Open your Excel file (stays on this computer)
Drag it into this box or click below — .xlsx, .xls or .csv
Takes only a few seconds
✓
Cleanup complete
Only the first worksheet is cleaned. Other worksheets, and any title rows above your table, are kept unchanged. Values, number formats and dates are kept; cell colors and fonts are not carried over. Row numbers refer to your original file.